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.
on 05-05-2016 03:33 PM - edited on 07-27-2021 11:41 PM by APIUserOpsDM
If you’ve gotten accustomed to having headers and sub-headers (fields/sub-fields) in your tables, much like those you can build with the “Merge & Center” Excel feature, you’ll be happy to hear with just a couple formatting steps we can build the format below:
In Alteryx, with similar formatting:
The attached workflow goes into the details of the approach, but the essence is below:
There you have it! Your tables are now rendered in style.
I have an Excel file which contains two headers (the top one is usually merged) and i need both of them. How can i use this in Alteryx? Can i combine the 2 together so that each month has the top header name in it?
The brand column at the top is actually merged all the way across but for some reason doesn't show on here.
Group | Brand | |||
QTR ending May-19 | Apr-19 | May-19 | QTR ending Feb-19 | QTR ending May-19 |
@MattD If I want the results of your flow to be in excel (.xlxs) format, can I do it?
I tried that but for some reason the width of the column groups varies and I have absolutely no clue why, it's as if Excel would be arbitrarily deciding what columns need more space than others (screenshot below). Changing the report type in Render tool to custom does help a little bit, but only If you can find the width that is just right for a given columns sets. The problem with that approach is that if the columns need more space (e.g. the value is longer) they would get trimmed...