Mapping countries to regions mapping table

[dareinnyc]

Looking to map multiple data sources with countries to regions. 

Example attached. Thanks.

[fmvizcaino · Accepted solution]

Hi @dareinnyc ,

You can achieve that by using find/replace or join tool.

The difference between both is that find/replace works like vlookup where you get null values when don't find a match in your mapping tool and the join will separate in the J anchor all that have a match and in the L anchor all that haven't.

Best,

Fernando Vizcaino

[dareinnyc]

Could you kindly show me an example? Thanks!

[fmvizcaino]

Hi,

There is a workflow attached with both examples.

If you access the post directly in community, you will be able to see it.

Best,
Fernando V.

[dareinnyc]

Thanks!