Hello Uipath Masters!
Can anyone help me with the following? This is a little tricky so please let me know if you know how to figure this out.
I have two data tables (both come from SharePoint sites) when I pull the two data tables I want to compare one column from DT1 with another column in DT2. If a ‘name’ or ‘code’ exists in both data tables in the same column, I then want to update DT1 to include an extra column with value ‘Yes’ for the row in DT1. Does that make sense? I know this is difficult so would be very grateful for any help
Column 2 in DT1
Column2 in DT2