Hello Alteryx Community. I have attached a file, where the main header of all columns breaks into multiple rows. For designing Alteryx formulas, we will need the top header of each column in one line/cell instead of multiple lines/cells. Is there a shortcut in Alteryx to merge multiple rows of a header to one cell ? Or we have to do it manually before running the Alteryx ? Please refer to the attached file for more details. I have left comment inside the attached file for better understanding, I have attached a sample client data and the desired output of what am looking for.
Solved! Go to Solution.
Hi @AroopChand ,
Its possible. Can you provide a sample at least with one or two rows. I can prep up a proper workflow.
Hi.. I have attached the sample in original query, refer to rows 3-10 in Sheet 1. Let me know if that works to run a simple workflow.
Hi @AroopChand ,
I was able to pull up a similar sample data. You file is not properly structed for a workflow.
Here is a workflow for the task.
Input
We need to read it as First row as Data in Input tool
Input now
Output
You change - to anything else in summarize
Workflow
Hope this helps : )
If this helps please mark the post as solution. And give a like if you dont mind : )
Hi @AroopChand ,
If this solves your usecase please mark the post as solution.
If not let me know the concerns i will help you out with it.
Thanks a lot. Regards.