Mapping two excel sheets

Help Studio
1

I have 2 Excel files which is Input and Master. I need to do the mapping in between those files. For example

  1. Input file has the header as - EMP I’d
  2. Master File has the header name as - Employee code.

Now I need to update the data which has EMP I’d into Employee code.

Could you please help me.

2

This is called a join. It’s a standard database operation. The activity you want to use is Join Data Tables.

3

Hey @sivaranjani.shiva ,
You can do these steps in studio to get a solution.

  1. Use the “Excel Application Scope” activity to open both the Excel sheets.
  2. Use the “Read Range” activity to read the data from both the sheets into separate data tables.
  3. Use the “Join Data Tables” activity to join the data from both the sheets based on a common column. This will create a new data table with the merged data.
  4. Use the “Write Range” activity to write the merged data back to a new Excel sheet.

I hope this helps you! Happy Automation :grinning:
Mark this as a solution if you find this helpful.

Regards,
@pratik.maskar