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...

Was this article helpful?
Cancel
Thank you!