How to transpose dynamic columns into rows when using dynamic schema

[laughsmile]

Hello everyone

I am using dynamic schema to read data because the input file's column is changing dynamically.

How to transpose dynamic columns into rows?

Input File:

Articoli	561	575
Video	1049	1161
Tot	1610	1736

Expected Output:

Articoli	Video	Tot
561	1049	1610
575	1161	1736

Thanks in advance

Ryu

[Dave_Simo]

Hello,

You can achieve the expected result with a job design like below

Best Regards