topic [Qliksense] Load xlsx from path in App Development

[Qliksense] Load xlsx from path

Fri, 21 Oct 2016 14:13:58 GMT

Hello,

I'm trying to load an XLSX file in my load script in Qliksense 3.0.

I've found on the forum multiple post about this issue but whatever I try it fails. The error msg is "cannot open file *filepath*"

There is my load script

LOAD

column1,

column2,

column3

FROM 'F:\path\to\folder\myFile.xlsx'(ooxml, embedded labels, table is Feuil1);

I've tried without the "(ooxml, embedded labels, table is Feuil1)" (which is the one generated by Qliksense when I load the xlsx by lib connection).

Can you help me ?

Thanks

Re: [Qliksense] Load xlsx from path

sunny_talwar — Fri, 21 Oct 2016 14:18:41 GMT

I think QlikSense requires a different way to load the data by creating a connection.

Because of this connection that is created, the whole path is not required. There might be a way to use the complete file path, but I am not sure how to do that.

Re: [Qliksense] Load xlsx from path

sunny_talwar — Fri, 21 Oct 2016 14:19:58 GMT

I think this link might be helpful

Qlik Sense Legacy mode

Re: [Qliksense] Load xlsx from path

Fri, 21 Oct 2016 14:29:43 GMT

I've deactivated the "standard mode" as instructed and load files from a path works perfectly.

I want to load my extern files (xlsx, etc.) from a variable then I need to load them from a path.. The folder connection could work but hide the path from my GIT solution and I lose track of it. Really I need to load the files from a path and it seems to work fine in Qview then why not in Qsense ???

Re: [Qliksense] Load xlsx from path

sunny_talwar — Fri, 21 Oct 2016 14:31:10 GMT

I am not sure I understand your issue, can you try to re-explain?

Re: [Qliksense] Load xlsx from path

Mon, 24 Oct 2016 07:13:32 GMT

No problem, sorry if I was not clear.

I need to load an excel file from a path in the load script and not with a lib connection (folder connection in Qsense). The reason is that I want to parametrize the path automatically to detect if I'm on my production or test server. Then I have a variable to define my folder home path.

There is an example code:

SET vDwhHome ='F:\path\to\folder\'

LOAD

column1,

column2,

column3

FROM $(vDwhHome )\myFile.xlsx (ooxml, embedded labels, table is Feuil1);

If there is a syntax error it is not important, I tried every version of a valid syntax and at the end I even tried my full path load like this:

LOAD

column1,

column2,

column3

FROM 'F:\path\to\folder\myFile.xlsx'(ooxml, embedded labels, table is Feuil1);

And the error is "Cannot open file ...". It seems to be impossible to load an excel file from a path in Qsense... It appears to work in Qview just fine..