Move Field to Bottom

[clarrock]

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

Name	Age_1	Total	Age_2
Mark	2	3	1
Mai	3	8	5

How do I make sure that total is at the end at all times? 

[AngelosPachis · Accepted solution]

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

[pedrodrfaria]

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-havi... 

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.

[AngelosPachis]

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,

Angelos