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
@AnastasiaG One way of doing this
Bit hard-coded with sample tools - but we can do this with a transpose and summarize
Check out this example from the altertricks website:
Alteryx Design Pattern: Nested headers in Excel fileshttps://www.altertricks.com/design-patterns/alteryx-design-pattern-nested-headers-in-excel-files/
Chris
Thank you. It helped
Thank you. I used this solution in my flow and it worked