Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Dear Community,
I would like to seek for help if anyone know how to convert the original data header to the result as per screenshot below:
The challenging part is i need to combine different row header as one and also need to remove ( ) symbol starting from column I before combining it.
Output
I have also attached the excel file below for your reference.
Many thanks again in advance
Solved! Go to Solution.
Hi @SH_94
Here is how you can do it. The workflow is dependent on row number of header hence adjust row header number as required in the select record tool (highlighted below). Let me know if you face any issues.
Workflow:
Hope this helps : )
Attaching a sample workflow. Hope this is helpful.
