Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Check and mark a text if it contains a name from the list

Vnokhbeh
5 - Atom

Hi community,

 

I hope you can help to find a proper solution.

 

I want to mark teams from table 1 that have a member from table 2.

Table 1 contains in a column the list of team members together. Each new member is presented in a new line in the cell.

On the table 2, I have names that should be searched for in teams from table 1. (Tables are attached)

 

Thank you for your help in advance!

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Vnokhbeh 
I use the Text to Column tools to parse your table 1 by delimiter "\n", which means new line.

Then Join with table to find out there is a match or not.

1016-Vnokhbeh-A.PNG1016-Vnokhbeh-B.PNG

Labels
Top Solution Authors