Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi,
try putting \ in between below 2 variable
$(vCSVFileLocation)\$(vGuestFileName)
Regards
no need for \ , as i already define in variable........
still field not found error
I didn't found any error, I've done loaded success fully. Can you describe more for your Variables
can you share your script code/.....
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);
still same issue..........
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);
and how to remove these ""...as i want only column names without double quotes
Try removing the current load statement that contains variables and load it again using the load wizzard and see if the error still persists?