Need help to replace "for each row" as data table contains more than 30,000 rows

[jollie_ng]

Hi experts, i need help to automate the task of identifying people who bought items of different colors.

Below is a small snapshot of the table. Actually the table contains more than 30,000 rows with similar contents in the respective columns.

I would need to use UiPath for this task and i would not be able to use any activity with the word invoke due to organization policy.

I would be able to do this easily in excel by adding 5 additional columns.

1st column to to concatenate the first 2 rows. 2nd column to concatenate the first 3 rows. 3rd column for a countif to identify the number of repeats for the 1st added column. 4th columns for a countif to identify the number of repeats for the 2nd added column. 5th column is to check if the number in 3rd and 4th column are the same.

I have tried doing the UiPath process out and i will show my attempt in the screenshots below. However, the “for each row” activity is taking way too long for 30,000 rows.

Can someone please advise me a faster way? thanks

[jollie_ng]

[jollie_ng]

The correct output that i expect

[Anil_G (Anil Gorthi)]

@jollie_ng

I believe you dont need to use for each at all

even the concat can be done in excel and use auto fill range for all

Alternately you can use column expression

dt.Clumns("Name|Item|Color").Expression = "[Name] +'|'+ [Item] +'|'+ [Color]"

cheers

[jollie_ng]

hi @Anil_G

i get this error.

this is what is typed into the assign activity

dt_input.Columns(“Name|Item|Color”).Expression = “[Name] +‘|’+ [Item] +”|“+ [Color]”

[Anil_G (Anil Gorthi)]

@jollie_ng

For the second pipe as well use single quotes…please check above just now corrected it

Cheers