+7Hi all,
I’m running ifs-cloud-23.1.6-penyzy3-3.5.0
I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:
ADDRESS=4291 5th Ave E
S6V 7V6 - Prince Albert
Saskatchewan
CA - CANADA
In Excel export it looks like this:
4291 5th Ave E
S6V 7V6 - Prince Albert
Saskatchewan
CA - CANADA
How do I keep the information in the same record?
I’m assuming it’s processing a Hidden Tab from Excel .csv file
Thanks,
Rob
Best answer by Jens
Hi
the ADDRESS field is a kind of concatenation of the fields ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, ADDRESS5, ADDRESS6, COUNTRY, ZIP_CODE, CITY, COUNTY and STATE based on the “Address Presentation” (search for that in the Client navigator) setup.
So if you update one of these fields then the ADDRESS field will automatically be updated as well.
/Jens
+10Hi
the ADDRESS field is a kind of concatenation of the fields ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, ADDRESS5, ADDRESS6, COUNTRY, ZIP_CODE, CITY, COUNTY and STATE based on the “Address Presentation” (search for that in the Client navigator) setup.
So if you update one of these fields then the ADDRESS field will automatically be updated as well.
/Jens
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.