Merge columns of a file

[idembel2]

Morning Guys,

I have a file looks like bellow and i want to merge all rows which have the same ID (first column) in a single row.

ID	Test_1	Date_test_1	Test_2	Date_test_2	Test_3	Date_test_3
1	yes	06/09/2017	 	 	 	 
4	no	 	yes	20/04/2004	 	 
4	 	01/10/2000	 	 	yes	17/05/1982
1	 	 	no	02/02/2015	 	 

I try to use tAggregateRow component but it does not help in my situation; because colums can contain or not data and i have not function to extract it.

I want to get an output like bellow.

I also see on this link : https://help.talend.com/reader/ZndcSsDNtKg8FpNIRCdjag/jPZNgHRF5ad4KUp4Mpvzkg

Which suggest to use component tSurviveFields but it does not present on Studio and not on talend Exchange

ID	Test_1	Date_test_1	Test_2	Date_test_2	Test_3	Date_test_3
1	yes	06/09/2017	no	02/02/2015	 	 
4	no	01/10/2000	yes	20/04/2004	yes	17/05/1982

Thank you for help,

[idembel2]

Hello TRF,

Really, i am very happy to know that, so it is possible perhaps one day to meet you