Forum Discussion
Sort column by value
Hi Sophie_
In the Query Editor (Transform data) go to your table and choose reference.
Then highlight the two columns to keep and choose remove other columns. Then choose Remove duplicates
Join this back onto your table in the front end and use this column instead of the original.
Hello SamWiseOwl ,
do you have an exemple to di this : "
Remove duplicates and then apply your sort.
Then join back to your original visual. That would remove the error as the seperate table is unique." ?
I want to sort partner_display in filter.
Sophie
Hi Sophie_
In the Query Editor (Transform data) go to your table and choose reference.
Then highlight the two columns to keep and choose remove other columns. Then choose Remove duplicates
Join this back onto your table in the front end and use this column instead of the original.