Filed not found error but script is correct

[qliklearnervir]

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 .

[Anil_Babu_Samineni]

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