How to add a merged header to my data?

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?

Help

Accepted answers

binu_acs

@zqlcancer I updated @atcodedog05 workflow with your data.

Copy of Column header merge.yxmd

All comments

binu_acs

@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/974692

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

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.

binu_acs

@zqlcancer I updated @atcodedog05 workflow with your data.

Copy of Column header merge.yxmd

zqlcancer

@binu_acs 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.

binu_acs

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

zqlcancer

@binu_acs 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.

Column header merge and saved to different files.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703