We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Replace accented characters with english character

AtrayeeDutta
Regular Contributor
Regular Contributor

Hi Team,

We have an requirement to replace accented characters with English character,

like O'Brien should be OBrien, I tried adding a row in dataset in REPLACE_MAPPING but it shows below error.

2023-08-02T12:22:26.976667078Z stderr F 02-Aug-2023 12:22:26.976 WARNING [http-nio-8080-exec-20] groovy.sql.Sql.executeUpdate Failed to execute: UPDATE TEMPNEWUSERS_45291 SET customproperty40 = FN_EIC_REPLACE(lastname,null) because: Table 'ssminlp.DATASET_VALUES' doesn't exist.

Iam using preprocessor json from upload user 

when I give AtzÌ„ (zÌ„  is default value in REPLACE_MAPPING dataset) in my csv as lastname after import lastname is coming as AtZÌ„

How can we handle this? anyone faced this problem before, please let us know how to resolve this.

Regards

 

 

 

2 REPLIES 2

dgandhi
All-Star
All-Star

Can you ping the entire query that you are trying?

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

AtrayeeDutta
Regular Contributor
Regular Contributor

Hi Devang,

This is the preprocessor JSON

1.

{
"ADDITIONALTABLES": {},
"COMPUTEDCOLUMNS": [
"customproperty40"
],
"PREPROCESSQUERIES": [

"UPDATE NEWUSERDATA SET customproperty40 = FN_EIC_REPLACE(lastname,null)"
]
}

 

2.

{
"ADDITIONALTABLES": {},
"COMPUTEDCOLUMNS": [
"lastname"
],
"PREPROCESSQUERIES": [

"UPDATE NEWUSERDATA SET lastname= FN_EIC_REPLACE(lastname,null)"
]
}

Lastname is having the special character.

Regards

Atrayee