Alteryx Designer Desktop Discussions

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

Verifying data from one column is found in another.

cvaloren
5 - Atom

I am trying to make a workflow that would look at the data in [Home State] column and verify that that State is listed among the States listed in [Licensed States]. I've included a sample of the data. 

3 REPLIES 3
alexnajm
16 - Nebula
16 - Nebula

How about a CONTAINS statement? Workflow attached:

Qiu
20 - Arcturus
20 - Arcturus

@cvaloren 
Trying to be smart and not to use Contains function. 🤣

0215-cvaloren.png

grazitti_sapna
17 - Castor

@cvaloren The easiest method is to use a formula tool to achieve the desired result. Please try the below workflow to get the desired output. Let me know if you have any questions.
Thanks

Sapna Gupta
Labels