I am just new to UiPath and I am in need on how this scenario will be automated.
I have 2 excel sheets. Sheet 1 will be the reference of checking. On the ID column of Sheet 1, it will compare all area codes (sheet2) that have the same ID number from sheet 1.
On column E (mismatch), the column name which has a mismatch from sheet 1 will be written and be separated by comma like in row 8 in sheet 2.
In addition, if cell is blank from sheet 1 and sheet 2, it will be considered as matched.
Thank you in advance for any help. It would be helpful if XAML is provided.
This is the Sheet 1
This is Sheet 2