Dynamically reordering columns in mapping data flow without using Fixed mapping

Question

I want to reorder column names based on an array input parameter within Data Flow

Example -

Actual Order of columns - id, firstname, address, phoneNumber

Order Needed - id, address, phoneNumber, firstname

I use a parameterized Array to state expected order - ["id","address","phoneNumber","firstname"]

I want to re-arrange columns based on this Array on the fly dynamically without using Fixed Mappings in Data Flow.

Can i achieve this using Select or Derived Column? Or is this impossible? I went through many Q&A similar to it and didn't got much around this.

Help!

Answer 1

Hi Kunal sharma

You can use select transformation. Please see if below screenshots help.

My source file schema

My data flow parameter settings:

As you can see, i have changed order of columns in array.

Next, Select statement settings:

Now, looking at the preview of sink:

Hope it helps. Please try and let us know.

Thanks