Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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