Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Match String from data in another sheet

tahertalib
7 - Meteor

Hi ,

I have a dataset which contains data in the below format:

 

CID

Task

300005913  Co12345 05AAAA101000268BBA00

T1
300005913  Cp67891 05BBBB101000270BBA00T2
300005913  Cm11333 05CCCC101000283BBA00T3
05WWWW101000287BBA00T4
05WWWW101000289BLBBA00T5

 

The second dataset which contains CID_new info:

 

CID_New

05AAAA101000268BBA00

05BBBB101000270BBA00
05CCCC101000283BBA00
05XXXX101000287BBA00
05QQQQ101000289BBA00

 

How can i lookup data from the 2nd dataset to 1st dataset? I want to add a new column in first data set(True or False) based on lookup results from second dataset.

If CID_New(Full string) is present in CID column from 1st dataset, it should return true.

 

Thanks

1 REPLY 1
tahertalib
7 - Meteor

Used the Find and Replace function and was able to get this working. Thanks

Labels