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

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
10 REPLIES 10
ChrisTX
15 - Aurora

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

AngelosPachis
16 - Nebula

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
16 - Nebula

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