Rows to columns

Anonymous — Thu, 09 Apr 2020 12:48:47 GMT

Hello everyone

I read every topics but didn't find what I'm looking for.

I have 2 columns see on screenshot.

The first one is a standarded structure with specifics numbers and the second column is the datas. The first colums can repeat itself many times.

So I would like to have the almost 4 hundred differents structures in 4 hundred columns, with every datas in a row below the column.

The best I succed was with tpivottocolumnsdelimited

I succed this

But I want that

And if possible, repeat the empty cells with the previous datas above.

I don't know if it's possible, with componant, java, ...?

I think The tPivotToColumnsDelimited component is good, except that the results should not be grouped by the "Group by" option, by a column, but that Talend will transfer the data as long as it finds the correct column address going from left to right, then as soon as he can no longer find the match, he goes to the line to repeat a round and find the right column and paste the data again from left to right.

You will find an exemple of the inputfile.

Thank you

Boris

PS 2020/04/10 With TMAP, I have the same as tpivottocolumnsdelimited

For this exemple, I tried to extract only adresse 23, but I have 65000 empty rows and a scaled result for my adress 23

topic Rows to columns in Talend Studio

Rows to columns