Mapping

Learning & Development Programs Automation Starter
3

Try to follow below steps:

  1. Use activity Read Range to get the data from first excel file to a DataTable variable e.g. dtFileOne
  2. Use activity Read Range to get the data from second excel file to a DataTable variable e.g. dtFileTwo
  3. Use activity Merge Data Table to merge data tables

Your workflow will look like this one.

Untitled
Untitled467×563 12.3 KB

I hope this will be helpful.