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.
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
18 - Pollux
18 - Pollux

How about a CONTAINS statement? Workflow attached:

Qiu
21 - Polaris
21 - Polaris

@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
Top Solution Authors