Dynamic Rename Fields

sneha_bhiwagade1

Hi Team,

I hope you are doing well!!

I am having an excel file with two different sheets and one mapping file

Sheet 1

name

roll no

gender

age

Sheet 2

abc

1

m

10

Mapping file

name	roll no	gender	age
abc	1	m	10

Based on the mapping file I would like to join the data based on roll no column for both the sheets. Although sheet 2 is not having the headers as we are having the direct data. i would like to get the headers first for sheet 2 and then perform the join based on roll no.

Could you please help me to achieve this.

Many Thanks in advance

Spainey

Hi @sneha_bhiwagade1,

I believe the best tool for this job is the Dynamic Rename tool. Since you have a Mapping File, we can use that, but you could also use Sheet 1's headings for this method if you did not have a Mapping File. Configuration would be exactly the same as below, but connecting Sheet 1 to the Dynamic Rename instead of the Mapping File. 

 

 
You should end up with both data sources in a single table, like this:

Dynamic Rename Fields from 2 Sheets.yxzp