Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jduarte12
Partner - Creator II
Partner - Creator II

Store resident table to qvd file issue

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

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

dt_c:

NOCONCATENATE

load

    field1,

    average1

resident dt_c_tmp;

View solution in original post

3 Replies
m_woolf
Master II
Master II

dt_c:

NOCONCATENATE

load

    field1,

    average1

resident dt_c_tmp;

tomasz_tru
Specialist
Specialist

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
Partner - Creator II
Partner - Creator II
Author

m w and Tomasz, thank you both.

Now it is working as expected.

Best regards,

João Duarte