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 .

[PrashantSangle]

Hi,

try putting \ in between below 2 variable

$(vCSVFileLocation)\$(vGuestFileName)

Regards

[qliklearnervir]

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

still field not found error

[Anil_Babu_Samineni]

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

[qliklearnervir]

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

[Anil_Babu_Samineni]

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);

[qliklearnervir]

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

[Anil_Babu_Samineni]

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);

[qliklearnervir]

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

[Anonymous]

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