Input Excel file clean up

[AroopChand]

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.

[atcodedog05]

Hi @AroopChand ,

Its possible. Can you provide a sample at least with one or two rows. I can prep up a proper workflow.

[AroopChand]

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.

[atcodedog05]

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 : )

[atcodedog05]

Hi @AroopChand 

I hope it helped your Usecase

[atcodedog05 · Accepted solution]

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.

[atcodedog05]

Happy to help : ) @AroopChand 

Cheers and Happy Analysing 😀

[AroopChand]

Thanks a lot. Regards.