topic Re: Transpose Column value into Rows in Talend Studio

Transpose Column value into Rows

rajesh90 — Thu, 17 Aug 2017 12:47:09 GMT

Re: Transpose Column value into Rows

Aukema — Thu, 17 Aug 2017 13:38:21 GMT

Perhaps this can help you?

the result

Incoming data

tExtractDelimitedFields Configuration

tDenormalize Configuration

Schemas, NOTE the key!

Re: Transpose Column value into Rows

rajesh90 — Thu, 17 Aug 2017 14:49:23 GMT

Perfectly working! Thanks!!

Re: Transpose Column value into Rows

rajesh90 — Thu, 17 Aug 2017 14:52:09 GMT

Quick check what is the difference between the tdenormalize n tdenormalizesortedrow?

Re: Transpose Column value into Rows

cterenzi — Thu, 17 Aug 2017 17:02:43 GMT

tDenormalize will build one output row for each key value or key group in the input, regardless of the order of the rows.

tDenormalizeSortedRow builds a new output group each time the key value or key group in the input changes.

It's easier to understand with a visual.

INPUT:

1|Seg_1
2|Seg_2
2|Seg_3
2|Seg_1
1|Seg_2
3|Seg_3
3|Seg_1
3|Seg_2
1|Seg_3

tDenormalize

1|Seg_1;Seg_2;Seg_3
2|Seg_2;Seg_3;Seg_1
3|Seg_3;Seg_1;Seg_2

tDenormalizeSortedRow

1|Seg_1
2|Seg_2;Seg_3;Seg_1
1|Seg_2
3|Seg_3;Seg_1;Seg_2
1|Seg_3

The sorted version can be faster and less memory intensive under the right circumstances. There may also be situations where you need to rely on the order of the input rows to group records.