Combination of 3 columns in rows

Hi, I need help regarding excel activity. I have one sheet in which I have to consider combination of 3 columns and according values under these columns, if the values are same for then it should be considered as 1 transaction. Kindly provide guidance.

Hi @chaitanya.panicker

Can you provide any eg or Screenshot which may explain it more so that it will be easy to give you the solution …

Happy Automation :raised_hands:

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

Maybe like this:

  1. For Each Row
    1.1 IF (row(0)=row(1) AndAlso row(1)=Row(2))
    1.2 varResult=row(0)
    1.3 Else varResult = row(0).ToString+row(1).ToString+row(2).ToString

The excel sheet format is like below:

Supplier no. Doc Type Doc no. Pay item
1123 PV 4000 002
12121 PV 9001 001
1123 PV 4000 001

I have to take combination of first 3 columns like this 1123PV4000 and find this similar combination in entire sheet which is to be treated as 1 transaction item. I hope it is easy to understand this way.

@chaitanya.panicker I did the same case earlier in my project and its very interesting and easy. Follow the below steps:

  1. Use Read range activity and store the result in datatable.
  2. Create a for each row loop for datatable
  3. Create a list of string (keep it in wider scope of for each loop) and Add column combination into list using Add to Collection
    row(0).ToString+row(1).ToString+row(2).ToString
  4. For each iteration check if the list contains the combination if exist then transaction is already processed if not then treat that as a new transaction item.

Hope it will help you🤪

1 Like

Thanks, I will try it today and let you know if it works