Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help with Mismatched Column Headers

christina2
5 - Atom

Hi all - I have a dataset that pulls down with merged column headers. When inputting the data into Alteryx, the headers un-merge into different rows. Is there an easier way to rename these columns without having to manually rename each one with the dynamic rename tool?

 

Small example attached. Thanks in advance!

 

christina2_1-1610861304713.png

 

 

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@christina2 

Will this help?

0117-christina2.PNG

messi007
15 - Aurora
15 - Aurora

@christina2,

 

another way to do it.

 

messi007_0-1610883208204.png

Attached the workflow,

 

Hope that helps,

Regards

Qiu
20 - Arcturus
20 - Arcturus

@christina2 

Thank you for the accept mark!😁

Labels