https://community.qlik.com/t5/Talend-Studio/How-to-read-multi-record-in-1-row-with-Excel/m-p/2215550#M11910 <P>This is my data in Excel</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-04-20 163457.png" style="width: 207px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Ef.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139998i4AA163558641970D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Ef.png" alt="0683p000009M9Ef.png" /></span></SPAN></P> <P>But, when I read it to talend,&nbsp;It does not display like excel file.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-04-20 163506.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9XQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134659iC47C78271175FD0A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9XQ.png" alt="0683p000009M9XQ.png" /></span></SPAN></P> <P>Please show me, How can do it?<BR /><BR /></P> Sat, 16 Nov 2024 02:38:30 GMT Anonymous 2024-11-16T02:38:30Z https://community.qlik.com/t5/Talend-Studio/How-to-read-multi-record-in-1-row-with-Excel/m-p/2215550#M11910 <P>This is my data in Excel</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-04-20 163457.png" style="width: 207px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9Ef.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139998i4AA163558641970D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9Ef.png" alt="0683p000009M9Ef.png" /></span></SPAN></P> <P>But, when I read it to talend,&nbsp;It does not display like excel file.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-04-20 163506.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9XQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/134659iC47C78271175FD0A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9XQ.png" alt="0683p000009M9XQ.png" /></span></SPAN></P> <P>Please show me, How can do it?<BR /><BR /></P> Sat, 16 Nov 2024 02:38:30 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-multi-record-in-1-row-with-Excel/m-p/2215550#M11910 Anonymous 2024-11-16T02:38:30Z https://community.qlik.com/t5/Talend-Studio/How-to-read-multi-record-in-1-row-with-Excel/m-p/2215551#M11911 <P>You can use a tJavaFlex component and store the value in the first column.&nbsp; Then when the first column is blank, assign it the value of the previous first column.&nbsp;</P> Mon, 20 Apr 2020 20:06:41 GMT https://community.qlik.com/t5/Talend-Studio/How-to-read-multi-record-in-1-row-with-Excel/m-p/2215551#M11911 billimmer 2020-04-20T20:06:41Z