topic Re: Filed not found error but script is correct in QlikView

Filed not found error but script is correct

qliklearnervir — Fri, 06 Jan 2017 07:38:48 GMT

Hi,

i am using below given scrip to load csv file from folder location.....

LOAD UID,

Title,

firstName,

lastName,

gender,

birthDate,

addressLine1,

addressLine2,

addressLine3,

zip,

country,

email,

mobile,

phone,

villagepreference,

"subscribe-mail",

"subscribe-email",

"subscribe-sms"

FROM

$(vCSVFileLocation)$(vGuestFileName)

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

but i am getting field UID not found error.

please suggest.

csv file attached .

Re: Filed not found error but script is correct

PrashantSangle — Fri, 06 Jan 2017 07:48:14 GMT

Hi,

try putting \ in between below 2 variable

$(vCSVFileLocation)\$(vGuestFileName)

Regards

Re: Filed not found error but script is correct

qliklearnervir — Fri, 06 Jan 2017 07:51:02 GMT

no need for \ , as i already define in variable........

still field not found error

Re: Filed not found error but script is correct

Anil_Babu_Samineni — Fri, 06 Jan 2017 07:56:08 GMT

I didn't found any error, I've done loaded success fully. Can you describe more for your Variables

Re: Filed not found error but script is correct

qliklearnervir — Fri, 06 Jan 2017 08:01:10 GMT

can you share your script code/.....

Re: Filed not found error but script is correct

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:05:37 GMT

This

LOAD ["UID],

["Title"],

["firstName"],

["lastName"],

["gender"],

["birthDate"],

["addressLine1"],

["addressLine2"],

["addressLine3"],

["zip"],

["country"],

["email"],

["mobile"],

["phone"],

["villagepreference"],

["subscribe-mail"],

["subscribe-email"],

["subscribe-sms"]

FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', msq no quotes);

Re: Filed not found error but script is correct

qliklearnervir — Fri, 06 Jan 2017 08:12:12 GMT

still same issue..........

Re: Filed not found error but script is correct

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:16:43 GMT

I didn't test that, Assuming. Check now.

LOAD ["UID],

[""Title""],

[""firstName""],

[""lastName""],

[""gender""],

[""birthDate""],

[""addressLine1""],

[""addressLine2""],

[""addressLine3""],

[""zip""],

[""country""],

[""email""],

[""mobile""],

[""phone""],

[""villagepreference""],

[""subscribe-mail""],

[""subscribe-email""],

[""subscribe-sms"""]

FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

Re: Filed not found error but script is correct

qliklearnervir — Fri, 06 Jan 2017 08:30:18 GMT

and how to remove these ""...as i want only column names without double quotes

Re: Filed not found error but script is correct

Anonymous — Fri, 06 Jan 2017 08:42:51 GMT

Try removing the current load statement that contains variables and load it again using the load wizzard and see if the error still persists?

Re: Filed not found error but script is correct

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:43:40 GMT

I don't think so, But you may do like this

You should do this by reload with these options and change direct from here. Then you will achieve

LOAD ["UID] as UID,

[""Title""] as Title,

[""firstName""] as firstName,

[""lastName""] as lastName,

[""gender""] as gender,

[""birthDate""] as birthDate,

[""addressLine1""] as addressLine1,

[""addressLine2""] as addressLine2,

[""addressLine3""] as addressLine3,

[""zip""] as zip,

[""country""] as country,

[""email""] as email,

[""mobile""] as mobile,

[""phone""] as phone,

[""villagepreference""] as villagepreference,

[""subscribe-mail""] as [subscribe-mail],

[""subscribe-email""] as [subscribe-email],

[""subscribe-sms"""] as [subscribe-sms]

FROM

(txt, codepage is 1252, embedded labels, delimiter is '|', no quotes);

Note: I would recommend to remove there directly, I mean this Store in CSV without double quotes