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