Hi Alteryx community, appreciate if anyone could provide some guidance here.
Issue:
When my table spans multiple pages, the column headers don't repeat on new pages.
This makes the report hard to read as users need to scroll back to see what each column represents.
What I've tried:
1. Looked through Table tool settings - couldn't find header repeat options
2. Checked Layout and Render tool configurations - no obvious settings for this
3. Attempted to break data into smaller tables with fixed number of rows - didn't work well because:
- Rows have variable heights
- Results in either page overflow or wasted space
- Not a dynamic solution
Question:
Is there a way to make table headers repeat on new pages using these standard reporting tools?
If not, what alternatives would you recommend?
Environment:
- Alteryx Version: 2023.2
- Output Format: Word document (.docx)
Attached a sample workflow. In this example, Key 3 spans across two pages.
Thanks everyone!
Solved! Go to Solution.
Hi @suwenchuan
I'm thinking you can do something like this. Create a Table that only has the column names and use it as the Header in your Render tool. Remember to uncheck "Show Column Headings" in your original table tool.
It's not pretty, but it works. You'll have to play around with fixing the alignment.