Hi Team,
I have an output that dynamically changes in terms of columns
But my total is not staying at the bottom and outputs as such
How do I make sure that total is at the end at all times?
Hi @clarrock ,
You can use a select tool before your output and make sure that your "Total" column is the last appearing in your list.
The key here is to place it after the "*Unknown" field, which is essentially fields that are not currently included in your dataset, but might exist in the future.
You can move the "Total" column to last using the up/down arrows in the configuration window.
Hope that helps,
Angelos
Hi @clarrock
I believe the solution you are looking for should be in this post below:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Use-a-Cross-Tab-without-having-the-data-rearranged/ta-p/92828
If you could also please provide how the dataset is before, we can display how to make sure it keeps the same order.
If you want to do it manually and a one time thing, you can simply use the select to reoder columns. You will have these options to move columns left to right:
Pedro.
Hi @pedrodrfaria ,
I don't think that the provided dataset is a result of a cross-tab because, as mentioned in the link you have provided, then fields would come in alphabetical order and this is not the case.
I believe the issue is more that you might have some columns creeping in your dataset which are not included when the workflow is created; hence the solution of the select tool provided earlier in my post, but thanks for iterating and providing a zoomed in picture of the arrow buttons.
Regards,
