topic Re: Load data from qvd into table in QlikView

Load data from qvd into table

Wed, 20 May 2015 13:14:53 GMT

Hi there,

i want to know if its possible to load data from qvd into SQL Anywhere table.

In my script i am loading data from a qvd file to qlikview:

qvd:

LEFT JOIN (table1)

LOAD

date,

Reason_Code,

amzsubcat,

product

FROM 'C:\test\new.qvd' (qvd);

In the qlikview file i want to export data like this:

For i= 0 to NoOfRows('C:\test\Verkäufe_neu.qvd') -1

LET V_FIELD1 = peek('amzsubcat',$(i),'C:\test\Verkäufe_neu.qvd');

SQL INSERT INTO TABLE(fr_ratenschema_kat) VALUES('$(V_FIELD1)');

NEXT;

But this doesn't work.

Any idea how to realize it?

Thanks and regards

Sabrina

Clever_Anjos — Wed, 20 May 2015 13:20:27 GMT

NoOfRows expects a table, not a QVD file, the rest of your code seems to be correct

You need to load it first

Temp:

LOAD * from C:\test\Verkäufe_neu.qvd(qvd)

For i= 0 to NoOfRows('Temp') -1

LET V_FIELD1 = peek('amzsubcat',$(i),'Temp');

SQL INSERT INTO TABLE(fr_ratenschema_kat) VALUES('$(V_FIELD1)');

NEXT;

Thu, 21 May 2015 05:30:13 GMT

thank you!!!!!