Load data from qvd into table

[#1]

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 · Accepted solution]

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;

[#3]

thank you!!!!!