QlikView not pulling data from qvds...

[divya_anand]

Hi All,

I am running a simple script-

for each vVar in 'A.qvd','AB.qvd'
table:
LOAD * FROM
;
next

store table into D:\blah\TEST.qvd;
drop table table;

When I run this, a part of the log file looks like this-

2016-11-30 07:02:07 0021 for each vVar in 'A.qvd','AB.qvd'

2016-11-30 07:02:07 0022

2016-11-30 07:02:07 0022   table:

2016-11-30 07:02:07 0023   LOAD * FROM

2016-11-30 07:02:07 0024  

2016-11-30 07:02:07         1 fields found: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>,

2016-11-30 07:02:07        7,287 lines fetched

2016-11-30 07:02:07 0025 next

2016-11-30 07:02:07 0026

2016-11-30 07:02:07 0022   table:

2016-11-30 07:02:07 0023   LOAD * FROM

2016-11-30 07:02:07 0024  

2016-11-30 07:02:07        1 fields found: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>,

2016-11-30 07:02:07        14,566 lines fetched

2016-11-30 07:02:07 0025 next

2016-11-30 07:02:07 0026

2016-11-30 07:02:07 0027 store table into D:\blah\TEST.qvd

2016-11-30 07:02:07 0028 drop table table

2016-11-30 07:02:07      Execution finished.

Why isn't Qlikview pulling the actual data records but instead is pulling the meta data of the fields?

Note: Using QV 12 SR4

[tamilarasu]

Hi Divya,

Always follow the correct syntax. Try this,

for each vVar in 'A.qvd','AB.qvd'
table:
LOAD * FROM
(qvd);
next

store table into D:\blah\TEST.qvd;
drop table table;

[marcus_sommer]

The same by storing:

store table into D:\blah\TEST.qvd (qvd);

- Marcus

[divya_anand]

Hi Tamil,

If I use this (qvd),  Qlikview is pulling data from qvds successfully. However, for some reason the 1st loop is creating table "table" and the 2nd loop is creating another table "table-1" instead of appending the data to "table" itself. Any solution?

[divya_anand]

Hi Marcus,

I am facing another issue when I use (qvd) as mentioned above.

Any suggestions?

[tamilarasu]

Hi Divya,

Could you confirm whether your qvd files consists same header names?

[tamilarasu]

Markus,I agree. But it's working even if we don't mention the "(qvd)", while loading from qvd. That's the reason I did not mention it.

Of course, we should mention the "(qvd)" while storing the qvd as well  and it's a good practice too.

[marcus_sommer]

Your tables will be only automatically concatenated if the table-structure is identically - if not you will need an explicit concat statement like:

for each vVar in 'A.qvd','AB.qvd'

let vConcat = if(noofrows('table') = 0, 'table:', 'concatenate(table)');

$(vConcat)
LOAD * FROM
(qvd);
next

store table into D:\blah\TEST.qvd (qvd);
drop table table;

- Marcus

[tamilarasu · Accepted solution]

If your qvd headers are not same, you can try like below.

Table:
Load '' as Temp AutoGenerate 0;

for each vVar in 'A.qvd','AB.qvd'
Concatenate (Table)
LOAD * FROM
D:\blah\$(vVar)] (qvd);
next

DROP Field Temp;
store Table into D:\blah\TEST.qvd (qvd);
drop table Table;

[divya_anand]

Hi Tamil,

Yes! got it.

Thank you.