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

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


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



Setup Info
      Help me…