Order columns based on a file

Is there a way to quickly rearrange the column order based on an input file ?
The current “reorder columns” transformation is not very handy for reordering a wide dataset.

Thanks in advance !

Hi,

In order to achieve this, you’ll need to:

  1. Create an empty dataset with column names in the required order by loading input file and removing all the rows.
  2. Append dataset with actual data to the empty dataset, created in the previous step.

Here is an example:

project.zip (9.1 KB)

Thanks Andrew !

That’s a nice solution.

You are welcome!

Smart & simple :grinning:
Bravo!