Reorder columns in output tab
Description
Currently, on the output tab of a recipe, you can see all the columns that will be output, and there are even "grab bars" (highlighted in yellow) that look like you should be able to reorder them, but the tool won't allow you to do so.
Impact
Visual clutter
Requires creating a prep step just to reorder columns in many cases.
Wasted storage
The extra prep step means another dataset that wouldn't otherwise exist.
Wasted processing
As with the wasted storage, this requires reprocessing the data, which typically doubles the processing time.
Suggested / Possible Fix
Allow users to use the "grab bars" to reorder columns in the output step. This would then alter the order the columns are selected in the SQL.
Comments
-
This would be a huge improvement! It'd be great if there were also checkboxes in addition to the grab bars, as columns are often needed as part of the internal query, but should be excluded in the output.
-
Thanks for sharing, I definitely hear you on this request - this is in our backlog already and we've noted your interest. Will let you know of any updates here!
If you’re reading this and would love to see this improvement too, be sure to kudos the original post or leave a comment!