Replace value from a column based on table (Match and replace)

Question

Hi all,

I have a column like this :

ATCBACBTFBA

And I have an other table like this :

AAPPLEBBEERCCOCA COLAFFANTATTONIC

I want all the value in the column of my first table to be replaced by the matching value in the table.

So final result should be :

APPLETONICCOCA COLABEERAPPLECOCA COLABEERTONICFANTABEERAPPLE

What is the quickest way to do it?

Thanks a lot for your help.

Best regards,
Axis

TheOC · Answer

hey @Axis

The easiest way would be the Find and Replace tool - or the Join tool.

Please find attached an example of both:

Axis.yxmd

RolandSchubert · Answer

Hi @Axis ,

I think,  you can use the Find Replace tool. Connect the first table to the "F" input anchor, the second table to the "R" input anchor. In configuration, "Find  Within Field" would be the field in table 1, "Find Value" would be the first field in table 2, in addition set Find to  "Entire Field" and "Replace Text" to  the second field of table 2.

Let me know if it works for you.

Best,

Roland

JosephSerpis · Answer

Hi @Axis one approach you can use is with a join tool. I mocked up an approach to showcase this. You can use the Find and Replace tool as well for a different approach.

Join_Table_03122021.yxmd