https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-merge-and-remove-duplicate-rows/m-p/2492329#M141501 <P>Hello,</P> <P>May I please ask for your help how I can achieve below data? I am using Talend Studio 8. I am quite familiar with Java and other components like tMap. Thanks in advance!</P> <P>&nbsp;</P> <P>Sample Data:</P> <TABLE class=" lia-align-center" style="width: 301px;" width="301"> <TBODY> <TR> <TD width="98">Name</TD> <TD width="20">ID</TD> <TD width="61">Date</TD> <TD width="61">Start</TD> <TD width="61">End</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> <TD>1/5/2024</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/5/2024</TD> <TD>1/6/2024</TD> </TR> <TR> <TD>SampleName2</TD> <TD>2</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Expected output:</P> <TABLE class=" lia-align-center" style="width: 301px;" width="301"> <TBODY> <TR> <TD width="98">Name</TD> <TD width="20">ID</TD> <TD width="61">Date</TD> <TD width="61">Start</TD> <TD width="61">End</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/6/2024</TD> </TR> <TR> <TD>SampleName2</TD> <TD>2</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> </TBODY> </TABLE> Tue, 12 Nov 2024 14:53:29 GMT archienesss 2024-11-12T14:53:29Z https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-merge-and-remove-duplicate-rows/m-p/2492329#M141501 <P>Hello,</P> <P>May I please ask for your help how I can achieve below data? I am using Talend Studio 8. I am quite familiar with Java and other components like tMap. Thanks in advance!</P> <P>&nbsp;</P> <P>Sample Data:</P> <TABLE class=" lia-align-center" style="width: 301px;" width="301"> <TBODY> <TR> <TD width="98">Name</TD> <TD width="20">ID</TD> <TD width="61">Date</TD> <TD width="61">Start</TD> <TD width="61">End</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> <TD>1/5/2024</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/5/2024</TD> <TD>1/6/2024</TD> </TR> <TR> <TD>SampleName2</TD> <TD>2</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Expected output:</P> <TABLE class=" lia-align-center" style="width: 301px;" width="301"> <TBODY> <TR> <TD width="98">Name</TD> <TD width="20">ID</TD> <TD width="61">Date</TD> <TD width="61">Start</TD> <TD width="61">End</TD> </TR> <TR> <TD>SampleName</TD> <TD>1</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/6/2024</TD> </TR> <TR> <TD>SampleName2</TD> <TD>2</TD> <TD>1/1/2024</TD> <TD>1/1/2024</TD> <TD>1/3/2024</TD> </TR> </TBODY> </TABLE> Tue, 12 Nov 2024 14:53:29 GMT https://community.qlik.com/t5/Talend-Studio/tFileInputExcel-merge-and-remove-duplicate-rows/m-p/2492329#M141501 archienesss 2024-11-12T14:53:29Z