Transpose Function Equivalent

Hellos,

I am sure it exists , but what' the transpose equivalent function in ETL to use?

I solemnly swear I searched the forums and wiki before posting this 

Cheers,
PM

Import scripts and transformations were designed to stream the data. 
So if you streaming 1 mln rows, how do you transpose it in into a table with 1ml columns?

So  there is no transpose function for the above.

As alternative you can use block transformation bit it works with excel only
www.etl-tools.com/wiki/advanced-etl-proc...n/rotate-data-block/

Having said all of the above, there are multiple ways to transform the data so if you provide us with the example we might be able to help you       

admin wrote:

Import scripts and transformations were designed to stream the data. 
So if you streaming 1 mln rows, how do you transpose it in into a table with 1ml columns?
 

Thank you for sharing this , I always wondered why Block Transformation was a separate entity and not clubbed inside transformations. As of now I am ETL amateur , these insights are appreciated.