It will result in the group Opening/Purchasing/Closing as the following photo.
Hi @hungdm, seconding @fmvizcaino's thoughts here, achieving the custom column header formatting in excel using Alteryx is possible, but tends to be an undertaking in itself.
For cases like these, I usually setup the template manually in excel, and have alteryx update the rows beneath these column headers (i.e. just update the table rows and not necessarily recreate the whole table). Attached is an example I put together to help you get a sense of my approach.
If you are using Alteryx version 2020, you have the option to skip field names in the output tool.
Hi @hungdm ,
Take a look at this topic.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Sub-headers-Sub-fields-in-Reporting-Tables/ta-p/20367
It is not an easy task and it is not pretty as you would think.
Best,
Fernando Vizcaino
@fmvizcaino
I tried the workflow of yours and it works like 80%.
There are several issues I noted in the photo below, and how to make border for the group of header text added?
Hi @AbhilashR,
Did you use the manually define table technique in this topic for your excel template?
