Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field not found but why? my field is right :(

Hi QlikCommunity,

My field seems right but why i keep tellig me that Field not found. Here is the script that i used.

Hope you help me and thanks in advance.

Owner:

LOAD tin,

    tctno,

    owner,

    address,

    admin,

    address2,

    "telno-1",

    "telno-2",

    lotno,

    "c-status",

    spouse,

    "et_al",

    others,

    "mode",

    "entry_date",

    BIRTin,

    AdmTin,

    OwnerNum,

    AdmNum;

SQL SELECT *

FROM PUB.Owner;

STORE Owner into C:\Users\SAMSUNG\Desktop\Lester RPTAS\QVD FILES\Owner.qvd;

//Get Data from QV database. (QVD FILES)

Owner:

LOAD tin,

     tctno,

     owner,

     address,

     admin,

     address2,

     [telno-1],

     [telno-2],

     lotno,

     [c-status],

     spouse,

     et_al,

     others,

     mode,

     entrydate,

     BIRTin,

     AdmTin,

     OwnerNum,

     AdmNum

FROM

(qvd);

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

Load *

FROM

(qvd);

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

Hi

"entrydate" is not available in ur qvd.

Please rename entrydate into entry_date

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Hi Mayil,

Thanks for helping me but I got another problem, the image below.
Thanks in advance

Untitled.png

MayilVahanan

Hi

Try like this

Load *

FROM

(qvd);

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.