How to add a merged header to my data?

[zqlcancer]

I need add a header to the existing table. e.g. I need add 'last period' and 'current period'. The problem is this header coming from original data are in merged cells.  Is it possible to do this? If I save this header in a file, is it possible to append it to my table data?

[binuacs]

@zqlcancer Here are some excellent articles by @atcodedog05  about how to merge cells in Alteryx

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746...

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

[FrederikE]

Hey @zqlcancer,

If your Input File is an excel (like-)file, the merged cells should end up in a single cell, which then might contain a "\n" (Enter). You can split this out.

It is important to note that in only the first cell (Left to right and top to bottom) will contain the information and you will need to tell Alteryx how to get it into the other cells. 

[binuacs · Accepted solution]

@zqlcancer I updated @atcodedog05 workflow with your data.

[zqlcancer]

@binuacs thanks for sharing, it is very helpful. But it seems this solution only works if I need generate one file only. In my case, I need group the data and generate several files by group column. As I combine data to table already, I can not see how to use the group to seperate the file.

[binuacs]

@zqlcancer can you upload a sample file and the expected output? 

[zqlcancer]

@binuacs in my case, I need to save the data to different files based on "segment". I am able to do this but the only problem is the merged header data don't align with details data.

i.e. in my example, The merged column header 'Same Day' is supposed to include data in column B,C,D and merged column header 'blank' should only include data in column A. However columns A&B are all included under merged column header 'blank'. Any idea what went wrong?

I tried several times and this only works if one of the merged column header is blank. If I input any data, I don't see any issue.