FIELD RENAME

[learnalteryx]

Hi 

Appreciate your help. I have concatenated excel data using python and there are several field names are different. I want to bring it together, when I tried dynamic rename tool I am getting Country,Country2,Country3 . Can anyone help ?

[FrederikE]

Hey @learnalteryx,

Field names need to be distinct in Alteryx, that's why you can't use the same name for multiple fields. 

[learnalteryx]

Is there anyway to rename it  to have a one single field called country?

[FrederikE]

Hey @learnalteryx,

Yes, of course. You could transpose it into a single field and then just rename this one. 

See the attached Workflow.

[hlee36]

I concatenated three columns into one new column and renamed it to Country and used the if statement to handle the edge case of concatenation of three nulls becoming empty string. 

[flying008]

Hi, @learnalteryx 

2 ways for you :

******

If help you get your want, please mark it as a solution and give a like for more share.