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 ?
Hey @learnalteryx,
Field names need to be distinct in Alteryx, that's why you can't use the same name for multiple fields.
Is there anyway to rename it to have a one single field called country?
Yes, of course. You could transpose it into a single field and then just rename this one.
See the attached Workflow.
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.
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.
