I know in the Enterprise edition you can sort by Ascending and Descending order within Edit Column but there is only an option of Hide under this menu on Dataprep. Suggestions?
Solved! Go to Solution.
A workaround could be to use a window function and orderBy the column you want to sort by.
(Note that the data is sorted for the window transform, but any subsequent transform (including the store transform) will most likely destroy the order.
Therefore, you will only be able to see the sorted dataset in your browser but when you output it, the order will not be preserved.)
In order to do this, you need to:
This is a very detailed response and has everything I need. Thanks for your help Hugues!