topic Re: How to extract a row with empty value from Excel? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353419#M119613 <P>@Ranjan Patel​&nbsp;, the rows should be extracted even though one of columns has empty value. What is the output you get?</P><P>​</P><P>Regards</P><P>Shong</P><P>​</P> Mon, 17 Jul 2023 03:48:42 GMT Anonymous 2023-07-17T03:48:42Z How to extract a row with empty value from Excel? https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353418#M119612 <P>We are trying to extract data from Excel *.xlsx file using tFileInputExcel component.</P><P>1st column with empty value is not getting extracted even though 2nd column has value.</P><P>Is there anything in Talend we can do to extract all of the data?</P><P></P><P></P><P>Here is the sample data:</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000kYGAiAAO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154615i4EB0F477FA0D59BF/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000kYGAiAAO.png" alt="0695b00000kYGAiAAO.png" /></span></P> Fri, 15 Nov 2024 21:34:45 GMT https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353418#M119612 rp2018 2024-11-15T21:34:45Z Re: How to extract a row with empty value from Excel? https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353419#M119613 <P>@Ranjan Patel​&nbsp;, the rows should be extracted even though one of columns has empty value. What is the output you get?</P><P>​</P><P>Regards</P><P>Shong</P><P>​</P> Mon, 17 Jul 2023 03:48:42 GMT https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353419#M119613 Anonymous 2023-07-17T03:48:42Z Re: How to extract a row with empty value from Excel? https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353420#M119614 <P>Had business fill in values in the 1st column and it worked.</P> Wed, 04 Oct 2023 14:37:13 GMT https://community.qlik.com/t5/Talend-Studio/How-to-extract-a-row-with-empty-value-from-Excel/m-p/2353420#M119614 rp2018 2023-10-04T14:37:13Z