topic Denormalize Multiple Columns in Talend Studio

Denormalize Multiple Columns

HLeyes — Fri, 02 Oct 2015 20:59:35 GMT

Hi all,

I am using the tDenormalize component in TOS. As in the first screenshot, each line has a site code, then a Model, Type, and Brand. My desired output to a text file is to have the site code, and then groups of the Models, Types, and Brands in that order, depending on how many pieces of equipment the site has. As it works now, all of the Models are displayed first (in yellow), then the group of Types (blue), then the group of Brands (red). Is there anything I can change to show groups of Models, Types and Brands for each piece of equipment?

Thanks in advance,

HL

Source data:

Talend settings on tDenormalize component:

Talend Denormalize Output to Text:

Re: Denormalize Multiple Columns

Anonymous — Sat, 10 Oct 2015 09:11:59 GMT

  Is there anything I can change to show groups of Models, Types and Brands for each piece of equipment?

What are you expected result? Can you please give us an example?

Best regards
Shong

Re: Denormalize Multiple Columns

_AnonymousUser — Mon, 06 Feb 2017 10:30:08 GMT

Hello I have a little problem, I have this
A | 1;2;3 | 1;2;3 | 1;2;3
B|4;5 | 4;5 | 4;5
And I want this
A | 1 | 1 | 1
A| 2 | 2 | 2
A| 3 | 3 | 3
B| 4 | 4 | 4
B| 5 | 5| 5
How can I do ?