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

[Axis]

Hi all, 

I have a column like this : 

A

T

C

B

A

C

B

T

F

B

A

And I have an other table like this : 

A	APPLE
B	BEER
C	COCA COLA
F	FANTA
T	TONIC

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 : 

APPLE

TONIC

COCA COLA

BEER

APPLE

COCA COLA

BEER

TONIC

FANTA

BEER

APPLE

What is the quickest way to do it? 

Thanks a lot for your help. 

Best regards,
Axis

[JosephSerpis]

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.

[RolandSchubert]

 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

[TheOC]

hey @Axis 

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

Please find attached an example of both: