Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Hi
Try like this
Load *
FROM
(qvd);
Hi
"entrydate" is not available in ur qvd.
Please rename entrydate into entry_date
Hi Mayil,
Thanks for helping me but I got another problem, the image below.
Thanks in advance
Hi
Try like this
Load *
FROM
(qvd);