How can I re-set the value order for column A as column B's order in the same table in Spotfire

[Xiaoshi Lu]

How can I re-set the value order for column A as column B's order in the same table in Spotfire

[Gaia Paolini]

If the two columns are both strings, you could go to Data > Column Properties then select column A and go to tab Sort Order then Apply Sort Order from Column.

 

This is what the documentation says about it:

 

 

 

 

 

[The options below are only applicable to String columns.]

To be able to apply a sort order from another column, there must be some matching values in the two columns. If the column with the sort order you want to apply for example contains months, the column you want to sort must contain some of the months. This means that you cannot use a column with months sorted alphabetically to sort a column with names alphabetically.