How to search/replace a column based on another table ?

Options
AmineCher
AmineCher Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 1

Hello,

I'm looking for a way to do a search/replace on a column based on a reference table that contains two columns:

Refrence_Table (WrongValueToMatch, Replace)

Table_Data (Col1, Col2, Col3, Col4)

I want to do a search and replace on "Col1" of the Table_Data table, I'll have to search for the values of the "WrongValueToMatch" column and if this value is found, I'll have to replace it in "Col1" with the value of the "Replace" column.

I'm looking to replace the character, not necessarily the exact value, for example :

WrongValueToMatch | Replace

é | e

and in Col1 I have "étoile" as the value, so I expect to have the value "etoile".

Thanks!

Answers

Setup Info
    Tags
      Help me…