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 .
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