topic Re: field not found when loading from qvd in QlikView

field not found when loading from qvd

felcar2013 — Mon, 11 Feb 2013 15:59:25 GMT

hi,

i created a qvd from a table "customer", but when i reload it, it always says "field not found <contact_id>". I do not know if i am doing something wrong, any comment would be very appreciated.

this is the table i call from the qvd

customer_x:

and this is the original qvw document

customer:

LOAD contact_id,

contact_acrm_dim_abc_segment,

contact_programcountry,

contact_dim_month;

SQL SELECT *

FROM DB_Name;

STORE customer into customer.qvd;

DROP Table customer;

Re: field not found when loading from qvd

swuehl — Mon, 11 Feb 2013 16:06:39 GMT

this is the table i call from the qvd
customer_x:
and this is the original qvw document

I think your post misses some details (about the qvd load statement here). Please post your complete code snippet (how you load from qvd).

Have you tried

LOAD * FROM customer.qvd (qvd);

and checked the field names?

Re: field not found when loading from qvd

felcar2013 — Mon, 11 Feb 2013 16:19:46 GMT

hi thanks for your help

sorry, yes, i forgot the load. it was like this originally: (now it works, i added the ".... (qvd) " at the end of the load statement and it worked.

customer:

LOAD contact_id,
    contact_abc_segment,
    contact_programcountry",
    contact_dim_month";
SQL SELECT *
FROM db_CV.dbo."tmp_20130208_Kundenwanderung_1;

STORE kunden into kunden.qvd;

DROP table customer;

customer_x:
LOAD contact_id,
contact_programcountry as programcountry1,
contact_dim_month as month1
from kunden.qvd;

Re: field not found when loading from qvd

Gysbert_Wassenaar — Mon, 11 Feb 2013 16:29:03 GMT

You create a table named customers, not kunden. So the line STORE kunden into kunden qvd doesn't store anything. And that's why if you load something from kunden.qvd you get an error. kunden.qvd is empty. Simply rename customers to kunden or store customers into kunden.qvd.

Re: field not found when loading from qvd

felcar2013 — Mon, 11 Feb 2013 16:52:07 GMT

thanks, yes this is only an spelling error, i just changed the names for the posting and forgot them.

Now it is working, i added the qvd in parenthesis at the end

thanks