Passing comma seperated values in csv schema

Situation:

I have a text schema activity using a comma in the field separator which is causing a field with Last Name, First Name to divide into 2 columns.

What is the correct method to apply for the field separator to column Direct Supervisor keep the value Last Name, First Name as 1 column?

 

Solution:

 

In your mapper try using this function.
concat('"',xpath of the Direct Supervisor field' from source,'"' )

Concatenate the value with double quotes. In other words put a double quote around
the source value using the concat function.

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.