Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Potential Formula

Jorddrick
5 - Atom

The goal here is to get the result in column D. There will be more current regions and current offices but I wanted to provide a small sample. The emerging market offices are in yellow and for now those will not change. Can you help with getting column D using Column A & BRegion Sample.JPG?

 

 

 

1 REPLY 1
pedrodrfaria
13 - Pulsar

Hi @Jorddrick 

 

I was not sure on the logic needed. But what I like to do when I have to compare a list with different values is to use text inputs for the list and the target. See below

 

pedrodrfaria_0-1609954714210.png

Pedro.

Labels
Top Solution Authors