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