Dynamically split data into streams by columns

[Biswarun]

My input data header is of the form:

A

B

C

A_FLAG

B_FLAG

C_FLAG

• There might be further pairs of column.
• A, B, C etc. will vary based on the incoming data.
  • That is, the first thee column headers might be Country, City, and Village. The next three, Country_FLAG, City_FLAG, and Village_FLAG. So on.

I want my incoming data to be split into streams for each pair:

A

A_FLAG

-----

B

B_FLAG

-----

C

C_FLAG

-----

So on....

[Ladarthure]

Hi @Biswarun,

you can do this by first doing a transpose then transforming the headers you used to have into new headers easier to read and catégories. Then you can do a cross tab to have the data in the format you want.

Find attached an example workflow doing this trick, you may have to tweak it a bit if you end up having field names (other than flags) containing _