Interview Usecase Scenario

[sharu_priya]

Hello All,

Case 1: I need to fetch all the fruit count without hardcoding the value. Eg: Orange =3, Banana=4

Case 2: I need fetch the past and future date.

How it can be achieved?

[ashokkarale]

@sharu_priya,

Don’t want to spoil your learning adventure so just giving you the pointers.

@sharu_priya

Case 1: I need to fetch all the fruit count without hardcoding the value. Eg: Orange =3, Banana=4

This would be achieved with LINQ Groupby

@sharu_priya

Case 2: I need fetch the past and future date.

Use LINQ to filter data based on Date of completion

Thanks,
Ashok

[sharu_priya]

Thank you so much for the pointers.

Will try to complete it and let you know.

[sharu_priya]

Partially i am getting the solution.
My input file is:

But while debugging, the input in the local panel seems different.

So i am getting the output as:

Can you please help me??
GroupByCount.xaml (8.2 KB)
AA Usecase.xlsx (9.9 KB)

[ashokkarale]

@sharu_priya,

Follow these steps.

1. Build Result data table like this using Build Datatable activity
   

2.Use this LINQ in Assign activity

(From row In dtInput.AsEnumerable() Group row By name = row("Name").ToString() Into Group Select dtResult.Rows.Add(name, Group.Count())).CopyToDataTable

Output:

[sharu_priya]

Thank you so much. It Worked