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