This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to generate a report using the table reporting tool aand was wondering how to create a multi row header. One way i was thinking was to create an additional row and format it to look like a header, but i need to merge rows to create the header and hence would not be able to use it,
While creating the data in Alteryx is a breeze, the multi-row header is something that you'll be wanting to do in Excel. While the version 11 of Alteryx may make you want to rethink that, if you are tied to the format desired you should consider outputting the data to Excel and having Excel setup to do the final formatting.
I found myself in a similar situation and pleased my end user by creating data and exporting it to a "RAW_DATA" tab in Excel. We formatted data tables (including pivots) that read the raw_data information. Each time the Alteryx module was run, the output was refreshed.
I'll be watching to see if there is an answer for creating these headers here. Until then, my approach does work.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
If you use fixed-width for the columns and also layout width, you can basically force everything to line up. In this example, it's very, very close... but the thickness of the cell padding (or maybe spacing) is causing a tiny variation. That could probably be accounted for as well, but hopefully it's close enough here. (see attachment).
I was able to implement your solution for the multiple headers but like you mentioned there is small gap between the headers. Have you been able to remove the spacing between headers as i haven't found a solution to that as yet?