Hi, I have one dataset and one Mapping file, example below:- Data FNLNSALADRESSJamesSmith100CALIFORNIARobertsWilliam200MAXICOMichaelBrown300HOUSTONDavidMillar400NEW YORK Mapping File :- New_ColOld_ColFIRST_NAMEFNLAST_NAMELNSALARYSALADDRESS1ADRESSADDRESS2ADRESSADDRESS3ADRESS 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_NAMELAST_NAMESALARYADDRESS1ADDRESS2ADDRESS3JamesSmith100CALIFORNIACALIFORNIACALIFORNIARobertsWilliam200MAXICOMAXICOMAXICOMichaelBrown300HOUSTONHOUSTONHOUSTONDavidMillar400NEW YORKNEW YORKNEW 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.

Rename the old column name with new column name

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.

Accepted answers

binu_acs

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

Dynamic_Renamce_1007.yxmd

All comments

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.

DynamicRename.yxmd

binu_acs

@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?

Dynamic_Renamce_1007.yxmd

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.

binu_acs

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

Dynamic_Renamce_1007.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703