Excel filteration on success and failure

Help Studio
, ,
1

I have an excel file in that i need the count how many are success and failure for each fruit.
Can you help on this please?

image
image283×565 4.91 KB

3

Thanks for the reply!!

but I need output as

Apple success /failure
Banana success /failure…etc

eg: Apple 3/5
where 3 as success and 5 as failure

4

Hi @Sachin_Sunny ,

Is this what you were looking for?

image

If so then please give this workflow a try.
FruitsCount.xaml (9.6 KB)

dt_data.AsEnumerable().
	GroupBy(Function(g) Tuple.Create(g("Fruits").ToString.Trim,g("status").ToString.Trim)).
	Select(Function(s) dt_data.Clone.LoadDataRow({String.Join(" - ",s.Key),s.Count},False)).CopyToDataTable()

Kind Regards,
Ashwin A.K

5

Thanks for the reply Ashwin

but I need output as

Apple success /failure
Banana success /failure…etc

eg: Apple 3/5
where 3 as success and 5 as failure

7

ashwin, I am unable to open the provided xaml i am getting following error

image
image1108×124 62.6 KB

8

Hi @Sachin_Sunny

Please try the following workflow:

FruitCount.xaml (10.9 KB)

Output:

image

Hope this helps,
Best Regards.

10

I’m using Windows, not legacy

image

dt_data.AsEnumerable().
	GroupBy(Function(g) Tuple.Create(g("Fruits").ToString.Trim,g("status").ToString.Trim)).
	Where(Function(w) Not w.Key.Item2.Contains("Failure")).
	Select(Function(s) dt_data.Clone.LoadDataRow({s.Key.Item1,String.Format("{0}/{1}",s.Count,s.Key.Item1.Count)},False)).CopyToDataTable()

image

FruitsCount_v2.xaml (9.6 KB)

Kind Regards,
Ashwin A.K

12

Hi @Sachin_Sunny

I have developed the solution for this. I am attaching the project document below. Please, check.
Fruits_CountTask.zip (197.5 KB)

I hope it helps!!