Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Setting up an e-mail recipient depending on country

howyoudoing
7 - Meteor

Hi All! I need to set up the workflow depending on country of incorporation. I have 4 options to determine who the message should be sent to, you can see it in the excel file (region and recipients). The issue here is also that I have just the countries of incorporations, not regions and Im considering if  there is needed to do 4 e-mails tool on every case and then manually combine to appropriate e-mail tool or there is another option? To be honest I have no idea how to connect it. I'm attaching my initial workflow, could you please help? The final result should be to have two separate e-mails depend on values - VenueCptyLEI and Country of Incorporation as the last table in the excel file marked in yellow.

1 REPLY 1
CoG
14 - Magnetar

You seem to need a map that identifies which countries belong to each of the available regions. Once you have that, you can join the email list to your main dataset via the map. You can then use the "Use Field" checkbox in the Email Tool for the "To:" field. I'm not sure how multiple email tools would help. Remember that the email tool sends 1 email per record in your dataset.

 

Hope this helps and Happy Solving!

Labels