How do I find the amount?

Hello everyone,
I want to find the amount of stair beams and steel by checking from A and C status.
I have the following information.
test.xlsx (9.6 KB)

Thanks.
Perawat

hi @Perawat

May i know that the data within Sheet2 how it is calculated ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

@Pratik_Wavhal

From Sheet 1 at the status column. The beam has a status in all 4.

Best Regards
Perawat

@Perawat Will the Status Column have only “a” and “c” status ?

@supermanPunch,
Yes, only have a and c

@Perawat Check this Workflow :
GroupByCount.zip (9.1 KB)

1 Like

Hi @Perawat

So here is the workflow for the same :-
MainPratik.xaml (11.7 KB)
test.xlsx (9.6 KB)

Output :-
image

I have used the Linq as below in assign activity :-

This will give the count for each data for Status A :-

(From d In readExcelFromSheet1.asenumerable Where d(1).ToString.Equals(row("Data").ToString.Trim) And d(2).ToString.Equals("a")).count

This will give the count for each data for Status C :-

(From d In readExcelFromSheet1.asenumerable Where d(1).ToString.Equals(row("Data").ToString.Trim) And d(2).ToString.Equals("c")).count

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.