Combining 2 Field names into one

[AnastasiaG]

Hello Alteryx Community,

In my input file, I have 2 rows that have field names. I need to combine these field names into one row. How would I do that?

Thank you,

Anastasia

[binuacs · Accepted solution]

@AnastasiaG One way of doing this

[ed_hayter]

Bit hard-coded with sample tools - but we can do this with a transpose and summarize

[ChrisTX]

Check out this example from the altertricks website:

Alteryx Design Pattern: Nested headers in Excel files
https://www.altertricks.com/design-patterns/alteryx-design-pattern-nested-headers-in-excel-files/

Chris

[AnastasiaG]

Thank you. It helped

[AnastasiaG]

Thank you. I used this solution in my flow and it worked