Rename and Merge Headers

Question

Hi Folks,

I have data in the columns highlighted in red below and i am trying to get to rename the columns and merge all the data in the new [Name_New] column created via dynamic rename. unfortunately i have had no joy with this expression:

IIF(CONTAINS([_CurrentField_],'Traveller Name'),'Name_New',[_CurrentField_])

Thanks!

MatthewBr · Answer

Why don't you use a dynamic rename tool?

ManuelRodrigues · Answer

thanks @KarolinaRoza I think that would concatenate the columns whereas i want to stack them one on top of each other [sorry if that was not clear]. i could union them but i have a few of these and that would be too much.

KarolinaRoza · Answer

hi @ManuelRodrigues

I think here you can use Formula tool to create new column:

and then Select to deselect old ones.

Karolina