Old Topic,
I bumped with this characteristic of Easymorph a few days ago.
I used the method describe in this post: Pivot Columns in Order - #3 by rebmanna to order the columns the same order as the rows.
@dgudkov Maybe I am not understanding the mechanic behind pivot action, but could you give more details why after pivoted a column is not keeping the order of the rows by default?
The current algorithm is hash-based and therefore it returns columns in a random order. To make them less random, we sort them.
Let’s make it a feature request. We’ll discuss it internally.
Moved to #feature-requests.
Hi Dmitry,
I have a scenario where our customer wants to sort the pivot table in descending order (from the most recent month to the beginning of the year). Instead of adding an option to the Pivot action, is there a way to select columns using checkboxes in the Reorder Columns action and then sort them in ascending or descending order? Alternatively, could it work similarly to the Rename with Lookup action, where the lookup could optionally sort the columns based on a column created with the Enumerate or "if then else" type actions?
Best regards,
Chris