https://community.qlik.com/t5/Talend-Studio/Optimizing-Data-Extraction-Merging-Complementary-Lines/m-p/2360609#M125158 <P></P><P>Hello,</P><P></P><P></P><P></P><P>Here is a simplified excerpt of the data I extract from a file. </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000ofQW0AAM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138860iB091EBC3DA132464/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000ofQW0AAM.png" alt="0695b00000ofQW0AAM.png" /></span></P><P></P><P></P><P></P><P>There are two types of lines for each ID. The data retrieved from these two types complements each other, meaning that the data from the 'PM' line fills in the null data from the 'PA' line, and vice versa. In order to retain only one line, I would like to merge these two lines to streamline the process afterwards.</P><P></P><P>To extract this data, I'm working with a tFileInputDelimited component, followed by a tJavaFlex component. I'm correctly extracting these two lines, but I'm unsure how to proceed afterward.</P><P></P><P></P><P></P><P>Thank you</P> Fri, 15 Nov 2024 21:22:45 GMT stephbzr 2024-11-15T21:22:45Z https://community.qlik.com/t5/Talend-Studio/Optimizing-Data-Extraction-Merging-Complementary-Lines/m-p/2360609#M125158 <P></P><P>Hello,</P><P></P><P></P><P></P><P>Here is a simplified excerpt of the data I extract from a file. </P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000ofQW0AAM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138860iB091EBC3DA132464/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000ofQW0AAM.png" alt="0695b00000ofQW0AAM.png" /></span></P><P></P><P></P><P></P><P>There are two types of lines for each ID. The data retrieved from these two types complements each other, meaning that the data from the 'PM' line fills in the null data from the 'PA' line, and vice versa. In order to retain only one line, I would like to merge these two lines to streamline the process afterwards.</P><P></P><P>To extract this data, I'm working with a tFileInputDelimited component, followed by a tJavaFlex component. I'm correctly extracting these two lines, but I'm unsure how to proceed afterward.</P><P></P><P></P><P></P><P>Thank you</P> Fri, 15 Nov 2024 21:22:45 GMT https://community.qlik.com/t5/Talend-Studio/Optimizing-Data-Extraction-Merging-Complementary-Lines/m-p/2360609#M125158 stephbzr 2024-11-15T21:22:45Z https://community.qlik.com/t5/Talend-Studio/Optimizing-Data-Extraction-Merging-Complementary-Lines/m-p/2360610#M125159 <P>Hi </P><P>What are your expected output? line type will be included in the output?</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Wed, 27 Sep 2023 05:48:08 GMT https://community.qlik.com/t5/Talend-Studio/Optimizing-Data-Extraction-Merging-Complementary-Lines/m-p/2360610#M125159 Anonymous 2023-09-27T05:48:08Z