Rename the old column name with new column name

[alt_tush]

Hi,

I have one dataset and one Mapping file, example below:-

Data 

FN	LN	SAL	ADRESS
James	Smith	100	CALIFORNIA
Roberts	William	200	MAXICO
Michael	Brown	300	HOUSTON
David	Millar	400	NEW YORK

Mapping File :-

New_Col	Old_Col
FIRST_NAME	FN
LAST_NAME	LN
SALARY	SAL
ADDRESS1	ADRESS
ADDRESS2	ADRESS
ADDRESS3	ADRESS

I want to replace the old column name from dataset to new column name which as per mentioned in mapping file.

So my expectation is below 

FIRST_NAME	LAST_NAME	SALARY	ADDRESS1	ADDRESS2	ADDRESS3
James	Smith	100	CALIFORNIA	CALIFORNIA	CALIFORNIA
Roberts	William	200	MAXICO	MAXICO	MAXICO
Michael	Brown	300	HOUSTON	HOUSTON	HOUSTON
David	Millar	400	NEW YORK	NEW YORK	NEW YORK

It would be great if you can help me to provide the expected output. As i tried with dynamic rename tool but it wont work if there is duplicate column name.

Please assist. Thank you in advance.

[apathetichell]

dynamic rename. connect your field map via the right anchor.

[Felipe_Ribeir0]

hI @alt_tush 

One way of doing this, considering that you have columns on mapping file that will or not will be on the dataset

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[binuacs]

@alt_tush One way of doing this with the dynamic rename tool as mentioned by @apathetichell 

Do want to copy the address field to Address2 and 3?

[alt_tush]

Hi binuacs,

Thank you for your prompt reply.

Yes, want to copy the address field to Address2 and 3.

And that is not work in dynamic rename tool.

So i need to understand how i can get the expected output.

As dynamic rename tool ignore other entries where new fields Add1,2 &3 mapped with same address field.

[alt_tush]

Hi Felipe_Ribeir0,

Thank you for your prompt reply.

I want to copy the address field to Address2 and 3 as well. As per the output table mentioned in my first post.

And that is not work in dynamic rename tool.

So i need to understand how i can get the expected output.

As dynamic rename tool ignore other entries where new fields Add1,2 &3 mapped with same address field.

[binuacs · Accepted solution]

@alt_tush One option is to create the additional columns using a formula tool. If that not works in your case let me know