Denormalize Multiple Columns

[HLeyes]

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:
   
 

[Anonymous]

  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

[_AnonymousUser]

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 ?