Alteryx Designer Discussions

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

If Statement Filter

corinne
6 - Meteoroid

Hi 

 

I have a file where I need to do the following. 

 

If [NAME] contains ("th") AND NAME Before "th" + NAME After "th" = [Street Name] then "19m"
Else "Blank"

 

In other words I do not want to select this record 

corinne_0-1603903707028.png

But I want to keep these 

corinne_1-1603903773448.png

 

Currently I am using a filter inside the formula tool (Contains = "th")

 

any help would be greatly appreciated. 

 

thanks

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @corinne 

 

your explanation is really confusing.

 

Can you explain again whats the logic you are using in this filtering which ones you want to keep and which one who want to remove.

corinne
6 - Meteoroid

Hi @

 

Sorry I was trying to figure it out with an If statement would work. I guess my way is confusing. 

 

What I want to do is...

 

keep this record. 

corinne_3-1603906733951.png

But not this record

corinne_2-1603906720016.png

 

As the Street_name column does not match with Name column. 

 

thanks

atcodedog05
22 - Nova
22 - Nova

Hi @corinne 

 

Here is a workflow for the task.

 

Input: I have added few more examples.

atcodedog05_0-1603907587980.png

Output:

atcodedog05_1-1603907642510.png

Basically the expected add words are st(1st),nd(2nd),rd(3rd),th(4th) only these are the occurring keywords.

 

Workflow:

atcodedog05_2-1603907727615.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

corinne
6 - Meteoroid

Thanks this is helpful. 

 

Is there a way not to create a new column?

reason is as per data specs I am not supposed to manipulate the data in the [Name] column. 

 

Thanks

atcodedog05
22 - Nova
22 - Nova

Hi @corinne 

 

There sure is. Put that all as nested formula in Filter tool.

atcodedog05_0-1603908101430.png

Workflow:

atcodedog05_1-1603908116657.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Labels