Replace accented characters with english character

[AtrayeeDutta]

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

[dgandhi]

Can you ping the entire query that you are trying?

[AtrayeeDutta]

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