Headers and Sub Headers in report

[praneshsapmm]

Hello there , 

I have this requirement of hardcoding the headers and sub hearders to while generating the out in Alteryx .

xxx is header1

YYY and ZZZ are Subheaders  .There is no condition , at any time these must be the headers and subheaders followed by the data . 

Headers and SubHeaders are not available in input file.

Can anyone help . 

Thanks.

XXX		Header1
YYY	Aging	Sub Header
ZZZ	2019	Sub Header1
JV	0.00	Data
D3	111.00
DE	11.00
SD	0.00
SW	0.00
Grand Total	122.00

[atcodedog05 · Accepted solution]

Hi @praneshsapmm 

Here is what you can do.

You use union to put header above data

Input:

Output:

Workflow:

You can set mapping on column name or position in union tool.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[grazitti_sapna]

Hi @praneshsapmm 

Please find the attached workflow. If you find it is useful please accept or like the solution.

[Qiu]

@praneshsapmm 
@atcodedog05 shoud meet your requirement. I have just made a minor modification to get the Grand Total and Union it with the header and data parts.
Give us a mark!

[atcodedog05]

Happy to help 🙂 @praneshsapmm 

Cheers and Happy Analysing 😀