I have workbook1 with payment details and other workbook2 with contact details. Common identifier in both is Parent ID (5050 workbook) in Account Account ID(in Contacts workbook) . For every row in workbook 1 take the Parent ID and search for account account id in workbook 2. After finding the account id in workbook 2, copy the contact details from workbook 2 to workbook 1.
Please help me in this. I am new to UI Path and trying to automate this process.