Compare Excel Data in the Same Column and Store Corresponding Rows Value

WhatsApp Image 2023-02-27 at 23.44.57
I want to compare and figure out data in a single excel column(id)

It will iterate till finding next new number , if new number found then it will check if downwards and figure out how many are there and will consider all of the corresponding values and store that in a DT

e.g, 1 appears here for two times, it will make a DT that contains the value of (aaa,bbb) and this DT will keep updating for each trx and we are considering (1…1) as a trx and 2 as a single trx.

I need assistance to solve this scenario.

Hi @Tanzill_Ahsan

Please refer from the below example, you can return information and store in datatable you want, feel free to ask if any question (9.0 KB)


1 Like

@fernando_zuluaga thank you

Your workflow is solving my scenario.

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