Changing Content of Column Based on Lookup Table

Question

Hi folks,

I was wondering if anyone had any ideas on changing the values in a column based on the values of a lookup table. If there is no match, then it should change to a default value. I've done the first part using the Find Replace tool, but I'm having trouble with the second part. I'd appreciate any help. Thanks!

Qiu · Answer

@altbc2 
I feel it is more a Join problem here.

1130-altbc2.yxmd

fmvizcaino · Answer

Hey @altbc2 ,

Something like this? Instead of replacing, append the field and include a condition to it.

Best,

Fernando Vizcaino

2021-11-29 Changing Content of Column Based on Lookup Table.yxmd