Hi all! I’m newish to uipath but had a question on how to go about making an automation for the problem below:
I would like to use a ForEachRow (the row is an invoice number) on DT1. If the invoice number does not exist in DT2 it appends the row to DT2. If the invoice number does exist on DT2, it replaces the entire row’s worth of data (minus a few columns, ← this is crucial) from DT1 into DT2.
Both DTs have identical Headers and can be adjusted if needed.