Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Mapping countries to regions mapping table

dareinnyc
7 - Meteor

Looking to map multiple data sources with countries to regions. 

 

Example attached. Thanks.

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

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.

fmvizcaino_0-1589509994978.png

 

 

Best,

Fernando Vizcaino

dareinnyc
7 - Meteor

Could you kindly show me an example? Thanks!


fmvizcaino
17 - Castor
17 - Castor
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
7 - Meteor

Thanks!

Labels