REad Data row in Excel and count

Help
, , ,
1

Hello Team,
Im trying to get the count of P,A,H,Please guide
image

2

@Mayyur you can read the excel data sheet into using Read Range which will output a DataTable for you. Then you can use For Each Row activity to traverse thru DataTable and create a local variable counter/counters to increment every time you find an occurrence say. row(ā€˜col1ā€™) equals ā€˜Pā€™ counter_P ++ else row(ā€˜colā€™) equals ā€˜Hā€™ counter_H++.

Additionally, you might also consider using DataRow variable for each Row being traversed to check each element of DataRow for values P/A/H!!

Try the logic around and share your workflow, if stuck!!

1 Like
3

I have around 30 columns,

4

iā€™m trying to calculate count for each name and for every P,H,A related to name

5

Seems like attendance data !! Anyways, I would say - ā€œconsider using DataRow[] variable for each row item being traversed and check with nested-if (guess 2 with be fine) element of DataRow for values P/A/H!!ā€ You would need to add another ā€œFor Eachā€ activity for to traverse thru DataRow.

1 Like
6

Can you please share a workflow similar to it for reference

1 Like
7

Here you go with a xaml
COUNT.zip (8.3 KB)

CHeers @Mayyur

8

image ,
Which activity it isā€¦Thanks

2 Likes
9

its just a FOR EACH LOOP
image

with expression like this
same for all three but with different characters
int_PCount + row.ItemArray.ToList().AsEnumerable().Where(Function(a) a.ToString.Contains(ā€œPā€)).Count

CHeers @Mayyur

1 Like
10

Yeah its working,but it is adding all P in both the rows,I want to separately count for each nameā€¦Thank u

11

GOt itā€¦Thank you

12

Cheers @Mayyur

13

Thanks alot Palaniyappanā€¦for being all time mentor as an when requiredā€¦

1 Like
14

@Palaniyappan expression you came up with is bang on :100: !! " int_PCount + row.ItemArray.ToList().AsEnumerable().Where(Function(a) a.ToString.Contains(ā€œPā€)).Count"

1 Like
15

Hey,Is there any other method of doing the same

16

This is more reliable and faster
Another method is using loop which might take more time
Thatā€™s why suggested this buddy
And by the way kindly mark the right comment as solution that would help others looking for ideas under your topic

Cheers @Mayyur

17

Sure bro,Im trying to do this with For each loop,getting errorā€¦

18

May I know the error you are facing
@Mayyur

19

Error- System.Data.Datarow to System.Collection.Ienumerable
image

20

I want to perform same processing using loopsā€¦like the above