How to arrange columns based on the sequence number from a lookup table?

Hi all,

I am having a scenario where I need to arrange my columns for a particular report. I can anyway do it via the select tool but since there are a lot of columns (250+), I want a better approach to rearranging my columns like we do in excel.

Here is a snippet of the Lookup table for the sequence:

And this is what the data looks like:

Please tell me if there is an easier and reliable way to arrange the columns other than the select tool.

Common Use Cases

Best Practices

Accepted answers

IraWatt

Hey @kishorerabhinav,

One option is to use the Union Tool, you can use your Column Order Table to set the positions of the headers then union all the other data underneath it:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

IraWatt

@kishorerabhinav the union tool has this option:

This will only allow columns which are in you reference table to be outputted.

All comments

IraWatt

Hey @kishorerabhinav,

One option is to use the Union Tool, you can use your Column Order Table to set the positions of the headers then union all the other data underneath it: