ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

Matching words from 3 different columns against 1 column

ben_d_jacob
7 - Meteor

Hi everyone, 

 

I would like to check if the Words (not characters) from column 1, column 2 and column 3 are in column A and it should not match null values.

 

Can you please suggest a method to do this.

 

I might not be able to share the screenshot as it is classified data

so, the columns 1,2 & 3 should look for values in column A as words...for example, in column 1 there is a word INT and in the same row in column A the word is INTERNATIONAL...this should not be a match
ChrisTX
12 - Quasar

Can you provide some fictional sample data?  For your 1 column, is there only one word in the column?

AngelosPachis
15 - Aurora

Hi @ben_d_jacob,

 

What you can do is transpose all columns you look to want into and then use a find & replace tool to look for certain words within those columns.

 

AngelosPachis_0-1613484313726.png

 

Then you can append a character ("y" in this occasion when the word you were looking for was found in a particular column

 

Hope that helps, let me know if that worked for you

 

Cheers,

 

Angelos

afv2688
16 - Nebula
16 - Nebula

Hello @ben_d_jacob ,

 

you can also achieve this with a filter tool:

 

 

 

 

Contains([Column A], [Column 1],1) OR
Contains([Column A], [Column 2],1) OR
Contains([Column A], [Column 3],1) 

 

 

Untitled.png

 

Regards

ben_d_jacob
7 - Meteor

Hi, The problem with this is,

 

In column 1, I have words like INT and in column A, I have words like MAINTENANCE.

 

So, Now it is matching because INT is there in maINTenance.

I do not want this, only if there is a word such as INT in my column A, then it should match.

 

 

Can you please help as this is a time sensitive matter

 

ben_d_jacob
7 - Meteor

removed image

 

 

AngelosPachis
15 - Aurora

Hi @ben_d_jacob,

 

In the workflow I attached above, if you look at the configuration window of the Find & Replace tool, you will see that there is an option that allows you to only Match Whole word Only.

Screenshot 2021-02-16 150449.jpg

If you check that checkbox, then probably the results will be what you are after

 

Cheers

 

Angelos

ben_d_jacob
7 - Meteor

Hi,

 

I cannot transpose the particular data. I need to work with the data as it is

ben_d_jacob
7 - Meteor

can we use a formula tool, that will check if the words in column A are there in Column 1, column 2 and 3?

afv2688
16 - Nebula
16 - Nebula

Hello @ben_d_jacob ,

 

How about using an unorthodox method like this filter:

 

Contains(' '+[Column A]+' ', ' '+[Column 1]+' ',1) OR
Contains(' '+[Column A]+' ', ' '+[Column 2]+' ',1) OR
Contains(' '+[Column A]+' ', ' '+[Column 3]+' ',1)

 

Not the most pretty one but should do it.

 

Regards

Labels