Articles on: Transforms

Reorder columns

The Reorder columns step enables you to reorder any of your existing columns..

Reorder columns





Input/output



In this example, the input data we'll use is a list of sales orders.




We can use the Reorder columns step to move our columns into whichever form that makes the most sense to us.

As seen in the below screenshot, we've reordered 4 columns out of 8 in the following sequence: "Sales Order Number", "Product Name", "Freight", "Order Quantity", then the rest of column becomes after the reordered columns.





Settings



Pick the dataset, then type in "Columns order" the list columns name or indexes per order separated by comma. Missing columns will be ordered last. Example: col1,col4,col3... or 0,4,3...

Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!