How to check the all the row values and update unique value in the particular column

Help Activities
, , ,
1

I have input sheet with the column. I need compare the first row of column headers only (Name,Type1 ,Type2, Date,Amount) values. If all the specified column values match with any of the row, then i need to update one same particular ID for both matched rows in column header “unique ID”.
Input&output.xlsx (10.0 KB)

Other rows filled with different IDs.

The Row 3 & 6 column headers (Name, Date,Amount) values are same but The column headers Typ1 & Type2 values are differ. So need to update the seperate ID. This logic also needs to handle.

Can someone help me out on this?
Thanks!!

2

You can have dictionary declare where key will be your column value calculations and result will be unique code
If the combination is not there and enter new code
Also other approach is you need to iterate through for each loop
Where first for each loop will start from row 1 it self and second should start row+1 and by this you can add further add logic to assign or write value in cell

1 Like
3

Hi @jast1631
Thanks for the reply, I will try and Can you provide the Xaml please.

4

Hi @jamuna_T

Can you try the below

This image depicts a workflow sequence in UiPath that reads an Excel file, assigns unique IDs to rows based on a dictionary, and then writes the updated data back to another Excel file. (Captioned by AI)
This image depicts a workflow sequence in UiPath that reads an Excel file, assigns unique IDs to rows based on a dictionary, and then writes the updated data back to another Excel file. (Captioned by AI)818×1787 88.9 KB

Sequence13.xaml (19.4 KB)

Output:

Input&output.xlsx (10.7 KB)

Regards,

1 Like
5

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