topic Re: How to merge some datas from differents rows in one row in Data Quality

How to merge some datas from differents rows in one row

Anonymous — Sat, 16 Nov 2024 04:58:57 GMT

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

Re: How to merge some datas from differents rows in one row

Anonymous — Tue, 13 Aug 2019 16:30:29 GMT

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

Re: How to merge some datas from differents rows in one row

Anonymous — Wed, 14 Aug 2019 08:54:17 GMT

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