Reorder columns

The Reorder columns step enables you to reorder any of your existing 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...