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

Contains join

Chris_Rodgers
6 - Meteoroid

Hi there,

        I have an interesting situation where I have a dataset that is between 150k and 250k items. For the most part, I will have a list that has generic names within the detailed name.  While I TECHNICALLY could write a formula that says "if the column contains the parent name / naming convention name, then give it the parent / naming convention name" but I was curious. Is there a way that I can write up in a text input category a list of parents and naming conventions (see below) and reference if the name is contained in the naming convention, then the output is the naming convention? 

 

The .yxzp file currently has a simple join but I dont believe there is a contains join. Has anyone ever run into this issue before? 

 

 Thanks

 

Chris

5 REPLIES 5
JohnJPS
15 - Aurora

Hi @Chris_Rodgers

 

Yep - check out the Find/Replace tool - it's tailor made for what you describe, including adding a field from your lookup table to the original dataset; (see attachment)

 

Hope that helps!

 - John

Chris_Rodgers
6 - Meteoroid

Thank you! @JohnJPS

Chris_Rodgers
6 - Meteoroid

I am looking at this now. My only issue is that the find and replace replaces a specific part of the word. Is there a way to replace the entire string?

JohnJPS
15 - Aurora

I would add the NamingConvention as a new field (in the Find/Replace settings), then follow with a Select tool to unselect the original column and rename "NamingConvention" to the original column's name.

Chris_Rodgers
6 - Meteoroid

@johnjps, Strangely enough, the find and replace tool is one that I havent played around with much and that was a great opportunity to learn. Thanks for your help!

Labels