Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Apply Column Rules to Multiple Columns in the Table Tool

rwicker
7 - Meteor

Is there a way to make a specific column always the last column in the basic table tool? Not sure if there is a formula that would work in the 'Column Rules'. 

 

Each time I run the workflow for a new month it puts that month at the end and the "Total" column is before it, not sure how to fix this. 

2 REPLIES 2
jarrod
ACE Emeritus
ACE Emeritus

the table works based on the incoming field order. what you can do is insert a select tool before the table and move the "Total" field to the very bottom (after the "*Unknown" field). any new unknown field will then be inserted between the latest year and the Total field.

 

Edit: you can do this directly in the Table tool by moving the "Dynamic or Unknown Fields" above the Total field.

rwicker
7 - Meteor

Thanks!

Labels