Hi Team i have template with names and subnames.
I want header names to be merged with cells.
can you please help me developing the same.
i have attached sample excel file with expected output img.
please help in generating the same.
Hi @suraj46nair
Here you go, following the guidance on this page ( https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/978794 ) i've built you this which gives the below output:
I've done no formatting or anything and on the Layout tool at the end I've had to make the config for Input_#3_Table specific width of 10% due to this being a single cell.
Also note on the Render tool its currently set to temporary excel.
Workflow attached!
You can do this using the Reporting tools, there is an excellent series of blogs on how to do this starting here - https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/974692
@davidskaife I did followed this article and tried to build based on provided steps. but it was bit confusing for me and i was not able to build the solution
@suraj46nair can you share what you had build so far and we can take a look?
@davidskaife
i used select tool after input tool and rename duplicate column with blank spaces.
and then i used table tool to try make them center align thats the workaround i used for timebeing.
I know its not best practice method to do.
PFA workflow.
thnx david this really helped.
