Store resident table to qvd file issue

[jduarte12]

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

[m_woolf · Accepted solution]

dt_c:

NOCONCATENATE

load

    field1,

    average1

resident dt_c_tmp;

[tomasz_tru]

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

[jduarte12]

m w and Tomasz, thank you both.

Now it is working as expected.

Best regards,

João Duarte