Iterate data load web links

Tue, 29 Sep 2015 10:43:11 GMT

Hello

I'm trying to migrate from Qlikview to Qliksense an App.

My load script is as follows, iterating an excel to extract some GoogleDrive links:

[Links Pipeline]:

LOAD Practica,

[Link Google Docs]

FROM [lib://DATA/Links Pipeline.xlsx]

(ooxml, embedded labels, table is NEW);

FOR i=0 to NoOfRows('Links Pipeline')-1

LET link = peek('Link Google Docs', $(i), 'Links Pipeline');

LET practica = peek('Practica', $(i), 'Links Pipeline');

LOAD Date(Date#(Concepto,'MMM-YY')) as fecha,

[T/C EUR-USD] as [EUR-USD]

FROM [lib://$(link)]

(html, utf8, embedded labels, table is @1)

Then, in QLikSense i'm gettin an error, cause the lib structure of the FROM sentence, but i cant create the new connection neede in Sense, cause i dont even know the links.

How it can be solved?

Thanks

Re: Iterate data load web links

lironbaram — Tue, 29 Sep 2015 11:19:41 GMT

one solution

is to chsnge the qlik sense settings to legacy mode

and then you can run your original script as in qlikview without lib's

you change the settings by going to the

C:\Users\YOUR USER\Documents\Qlik\Sense\settings.ini

you open the file for edit

and you change the standard reload from 1 to 0

your line should look like this

StandardReload=0

topic Re: Iterate data load web links in QlikView

Iterate data load web links

Re: Iterate data load web links