Unable to convert multiple columns to upper case while loading data as CSV | Community
Skip to main content
B
bitunsen
Level 2
September 8, 2021
Solved

Unable to convert multiple columns to upper case while loading data as CSV

  • September 8, 2021
  • 1 reply
  • 1674 views

Hi Experts,

I need one help in loading the CSV file through "Map CSV to XDM Schema" workflow. I have defined an XDM Schema which is extending "XDM Individual Profile". My file contains basic customer information (first_name, last_name, email_id, birth_date, address information). I want to convert the First Name and Last Name to UPPERCASE, email_id to LOWERCASE. I had added Calculated fields to use "upper" function for each of teh 3 fileds: first_name, last_name, email_id. When I finished the workflow, I could see that only first_name is getting converted to UPPERCASE, but the other 2 fields are being set as NULL in data lake and in Profile UI.

 

Can you please help me to know what is wrong? 

 

Thanks in advance. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Keshav-V

Hi @bitunsen 

 

Looks like data for country_code is missing and hence mobile column will be loaded as null. Besides, can you confirm your mapping looks something similar to the attached?

 

https://ibb.co/QX6T6PW

 

Keshav

1 reply

K
Adobe Employee
Keshav-VAdobe Employee
Adobe Employee
September 15, 2021

The Data Prep step will result in NULL if it is unable to transform the data. Since UPPER is a very simple operation, I am suspecting that the incoming data for other 2 attributes is something like a date or number that cannot be case converted. Can you please double check or post the sample input data (if not sensitive)?

 

Keshav

B
bitunsenAuthor
Level 2
September 16, 2021

Hi Keshav,

 

At first, thank you very much for responding. I have a simple CSV file having 1 record in it.

The data I am using is a mock data. See below:

 

id,first_name,last_name,email,birthDate,gender,addr_line_one,city,state,country,country_code,mobile
CRM001,Steve,Miller,steve.miller@aol.com,1986-05-18,Male,123 Main St,Midland,Texas,United States,254-467-2383

 

I wanted to convert the values of first_name and last_name columns to Upper case while loading the data using "Map CSV to XDM Schema" workflow. If I am adding 1 calculated field for any of the first_name and last_name columns, then the conversion is happening, but when I am adding 2 calculated fields (one for first_name and one for last_name), only one field is being converted to upper case and other one is set to NULL. 

Terms & ConditionsAccessibility statement

Loading footer...