How to merge some datas from differents rows in one row

[Anonymous]

Hello guys,

I want to extract datas from Talend to Excel, so i'm using a database table, with some others table on look-up into a tMap. And a tFileoutput excel as an exit.

You can see the result on the left of the picture. And you can see what i want on the right. 

Thank's

[Anonymous]

Hi,

   Please provide 5 sample input records and lookup records (not as image but as text data). Also please mention what is the expected output from that 5 records. Then we will get more idea on what you are trying to achieve.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Hello, 

This is kinda what i have as my input record. As a look up i got some more accurate informations that are not important in the process. So that's what i got : 

ID  |  PERIOD  |  Country  |  Quantity  |  Price 

1   |  2015  |  1  |  15  | 150

2  |  2015  |  1  |  20  | 40

2  |  2015  |  2  |  40  | 80

3  |  2016  |  2  | 6  |  12

And this is what i want as an output : 

ID  |  PERIOD  |  Country1_Quantity  |  Country_1Price  | Country2_Quantity  | Country2_Price

1  |  2015  | 15  |  150  |  0  |  0 

2  |  2015  |  20  | 40  |  40  |  80

3  |  2016  |  0  |  0  |  6  |  12

Sorry for the lack of accuracy in my first post. 

Thank you