How to merge data in excel based on matching account info

I have two sets of data that are being pulled from the FDIC. There is a data field that has the account/inst# that should match between both sets of data. I’d like to have UiPath grab both excel sheets data and merge it based on the matching inst#. I don’t have a problem getting the data to combine in one spreadsheet, but need to find a way to match up each row with that specific data point.

@trentm

Try using join datatable activity after reading the data on the matched column

Cheers

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