topic PDF to CSV and Data Restructure in Talend Studio https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253107#M36550 <P><FONT face="trebuchet ms,geneva" size="2">Hello folks,</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">I am extracting data from pdf to csv.</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">After extraction, the data is some kind of scattered and i need to assemble them cleanly.</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Scattered data from pdf to csv</FONT></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 348px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZsB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151502iE58D4386FD78CBDA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZsB.png" alt="0683p000009MZsB.png" /></span></SPAN></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">As you can see, the delimiter is | and the schema is different for each row.</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">What i am trying to do is to convert each rows into column:</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Expected result:</FONT></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 963px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ma3F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133837iAFEA65BA669B5FD3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ma3F.png" alt="0683p000009Ma3F.png" /></span></SPAN></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Is there a way to do that?</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">Please advice.</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Many thanks,</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">asadasing</FONT></P> Sat, 16 Nov 2024 02:26:32 GMT RA6 2024-11-16T02:26:32Z PDF to CSV and Data Restructure https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253107#M36550 <P><FONT face="trebuchet ms,geneva" size="2">Hello folks,</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">I am extracting data from pdf to csv.</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">After extraction, the data is some kind of scattered and i need to assemble them cleanly.</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Scattered data from pdf to csv</FONT></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 348px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MZsB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151502iE58D4386FD78CBDA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MZsB.png" alt="0683p000009MZsB.png" /></span></SPAN></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">As you can see, the delimiter is | and the schema is different for each row.</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">What i am trying to do is to convert each rows into column:</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Expected result:</FONT></P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 963px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ma3F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133837iAFEA65BA669B5FD3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ma3F.png" alt="0683p000009Ma3F.png" /></span></SPAN></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Is there a way to do that?</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">Please advice.</FONT></P> <P>&nbsp;</P> <P><FONT face="trebuchet ms,geneva" size="2">Many thanks,</FONT></P> <P><FONT face="trebuchet ms,geneva" size="2">asadasing</FONT></P> Sat, 16 Nov 2024 02:26:32 GMT https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253107#M36550 RA6 2024-11-16T02:26:32Z Re: PDF to CSV and Data Restructure https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253108#M36551 <P>Can you please share how you converted PDF to csv using which component?</P> Thu, 05 Nov 2020 14:42:43 GMT https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253108#M36551 Knowme 2020-11-05T14:42:43Z Re: PDF to CSV and Data Restructure https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253109#M36552 <P>it is a custom component which is available in talend exchange.</P> Fri, 06 Nov 2020 07:32:44 GMT https://community.qlik.com/t5/Talend-Studio/PDF-to-CSV-and-Data-Restructure/m-p/2253109#M36552 RA6 2020-11-06T07:32:44Z