Version

    Reorder columns

    Reorder columns step allows you to change ordering of columns within the data set. It does not modify the data in way, except for changing the relative positions of the columns within the data set.

    Parameters
    • Columns: required, a widget that allows you to reorder columns using the arrows to the left of the column list. Following actions are available in the list:

      Icon Action

      reorder icon up up

      Move the selected column(s) to the beginning of the data set.

      reorder icon up

      Move the selected column(s) by one towards the beginning of the data set ("up" in the list of columns).

      reorder icon down

      Move the selected column(s) by one towards the end of the data set ("down" in the list of columns).

      reorder icon down down

      Move the selected column(s) to the end of the data set.

      You can select multiple columns at once with Ctrl+click (or Control+Click on Mac). You can unselect one of the selected columns in the same way - with Ctrl+Click.

    Examples

    To change the order of columns so that Invoice amount column is the second column, use the widget to select Invoice amount and move it using arrows to the second place in the list:

    reorder columns
    Remarks
    • Reorder columns will work also if some of the columns you moved are no longer in the data set (this can happen either if you changed the steps before Reorder columns step or if your data source changed). In such case, the missing columns are ignored by the step and other column movements are performed as configured.