Create Multi Header Field

[PNau]

I am looking to parse my header by the underscore _ into multi headers (e.g., Name1_A_1 would become Name1 and I would then have either two new records under as A and 1 or two separate header fields if possible.  I created a new field as I could not see a way to have multi headers in the Crosstab tool :(

Happy with just being pointed in the right direction.

Thank you.

[tcroberts]

Could you provide a small example of your desired output? I feel like I understand the headers you want, I'm just not sure what data you would like under each of them.

Thanks!

[BenMoss · Accepted solution]

I've managed to get close to the desired output but one of the problems you will face is that you can't have repeated headers in Alteryx, i.e. Name 1 repeated three times as the header row.

Here's where I got too.

[PNau]

Thank you. .

Converting the Output to csv, alleviates the need to convert the fields to double, which would cause the headers that are not numeric to blank.

[PNau]

This solution helped me a couple of years later, thanks again!