Create Multi Header Field

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.

CreateMultiHeaders.yxmd

DesiredOutput.xlsx

Transformation

Help

Accepted answers

BenMoss

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.

CreateMultiHeaders.yxmd

All comments

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

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.

CreateMultiHeaders.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703