topic Re: QlikView not pulling data from qvds... in QlikView

QlikView not pulling data from qvds...

divya_anand — Wed, 30 Nov 2016 06:07:54 GMT

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

Re: QlikView not pulling data from qvds...

tamilarasu — Wed, 30 Nov 2016 06:18:13 GMT

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;

Re: QlikView not pulling data from qvds...

marcus_sommer — Wed, 30 Nov 2016 06:27:34 GMT

The same by storing:

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

- Marcus

Re: QlikView not pulling data from qvds...

divya_anand — Wed, 30 Nov 2016 06:39:58 GMT

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?

Re: QlikView not pulling data from qvds...

divya_anand — Wed, 30 Nov 2016 06:42:11 GMT

Hi Marcus,

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

Any suggestions?

Re: QlikView not pulling data from qvds...

tamilarasu — Wed, 30 Nov 2016 06:47:34 GMT

Hi Divya,

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

Re: QlikView not pulling data from qvds...

tamilarasu — Wed, 30 Nov 2016 06:48:26 GMT

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.

Re: QlikView not pulling data from qvds...

marcus_sommer — Wed, 30 Nov 2016 06:53:29 GMT

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

Re: QlikView not pulling data from qvds...

tamilarasu — Wed, 30 Nov 2016 06:54:50 GMT

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;

Re: QlikView not pulling data from qvds...

divya_anand — Wed, 30 Nov 2016 07:05:22 GMT

Hi Tamil,

Yes! got it.

Thank you.

Re: QlikView not pulling data from qvds...

divya_anand — Wed, 30 Nov 2016 07:05:45 GMT

Hi Markus,

Got that!

Thank you.

Re: QlikView not pulling data from qvds...

tamilarasu — Wed, 30 Nov 2016 07:13:10 GMT

Great Divya. Kindly close this thread by marking as correct and helpful. Have a nice day.