Alteryx Designer Desktop Discussions

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

Headers Column

NgaNgo
5 - Atom

I am using Alteryx to read the Excel name with multiple sheets. How can I create column headers from the first and second rows? Thanks in advance!

2 REPLIES 2
DataNath
17 - Castor

Hey @NgaNgo, here's how I'd go about this - Alteryx isn't great at handling stacked headers and so this approach just isolates the first 2 rows, concatenates them together and then replaces the original headers with this newly-combined field:

 

DataNath_0-1666166717472.png

NgaNgo
5 - Atom

Thanks so much .@DataNath 

Labels