topic Re: Loading pdf in QlikView

Loading pdf

Thu, 19 Dec 2013 17:17:19 GMT

Hallo,

is there any possibility to load pdf files, like in attachment?

Thank you in advance

Re: Loading pdf

Gysbert_Wassenaar — Thu, 19 Dec 2013 17:22:03 GMT

You can't use pdf files as a data source. And even if you had that in an excel file it would be almost impossible to load data from it. I'm not even going to try to think about how to achieve that.

Re: Loading pdf

Thu, 19 Dec 2013 18:24:25 GMT

Gysbert Wassenaar wrote:

You can't use pdf files as a data source. And even if you had that in an excel file it would be almost impossible to load data from it. I'm not even going to try to think about how to achieve that.

Yep reading from PDFs directly is not possible. You may be able to transform the data if it were in Excel - I have transformed and loaded similar datasets before - but it is tricky and actually loading pre-aggregated pivot tables is not really what QlikView was designed for. Better would be to find the data source of your PDF report and load the raw data into QlikView.

Re: Loading pdf

Thu, 19 Dec 2013 21:51:05 GMT

Hi,

thank you very much for your feedback.

I will try to convert the pdf in xls file and after to load it via ETL. For sure the best solution would be to get the data from the customer data source.

Thanks

Re: Loading pdf

Thu, 19 Dec 2013 22:23:36 GMT

i mean i use a sw to transform the pdf in xls and after that i load the xls.

The problem is that the position of the datas in the xls file, not alligned

as in the original pdf.

Il giorno 19/dic/2013 18:22, "Gysbert Wassenaar" <qcwebmaster@qlik.com>

ha scritto:

QlikCommunity <http://community.qlik.com/> Loading pdf
reply from Gysbert Wassenaar<http://community.qlik.com/people/gwassenaar?et=watches.email.thread>in
Scripting - View the full discussion<http://community.qlik.com/message/439374?et=watches.email.thread#439374>