topic Re: Store resident table to qvd file issue in QlikView

Store resident table to qvd file issue

jduarte12 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We are getting a "Table not found" error while runing the following script:

dt_c_tmp:

select

field1,

avg(field2) as average1 from abc

where field1 in (50224, 50225)

and timestamp >= to_epoch(date_trunc('day',_now() - interval '1 day'))

and timestamp < to_epoch(date_trunc('day',_now()))

group by 1;

dt_c:

load

field1,

average1

resident dt_c_tmp;

store dt_c into dt_c.qvd;

drop table dt_c_tmp;

We have several scripts written exactly the same way, and they are running without any problem. We have tried to run this in different folder locations, and even typing the file path in the store statement. We also restarted the server. However, the error message keeps showing, and the qvd file is not generated.

What are we missing here?

Thanks in advance,

João Duarte

Re: Store resident table to qvd file issue

m_woolf — Tue, 24 Apr 2018 16:51:56 GMT

dt_c:

NOCONCATENATE

load

field1,

average1

resident dt_c_tmp;

Re: Store resident table to qvd file issue

tomasz_tru — Tue, 24 Apr 2018 16:59:48 GMT

m w is right. But I believe explanation is needed. Both tables have the same field names so Qlik concatenate them into one (with the name of the first one).

Tomasz

Re: Store resident table to qvd file issue

jduarte12 — Tue, 24 Apr 2018 17:15:03 GMT

m w and Tomasz, thank you both.

Now it is working as expected.

Best regards,

João Duarte