Alteryx Designer Discussions

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

Advanced Filters

Gaetano_B
8 - Asteroid

Hello lovely people, 

 

I'm trying to get in column A the following output: 

 

Milestone: 0. Completion should NOT include: "10. KYC Complete" and "2. Pending Descope / Exit",  "2. Descope Confirmation" from col. B

 

1. QC Submission should NOT include: "10.", "2.", "8." and "9" from col. B

 

2. Business Connection should ONLY include statuses "0." and "3." from col. B

 

Would you be so kind to help?

 

Thanks, 

Gaetano

 

2 REPLIES 2
MarqueeCrew
19 - Altair
19 - Altair

@Gaetano_B ,

 

 from my iPhone it looks like there is a space after each decimal point.  

IMO the best way is:

 

left([col b],3) Not in ("10.", "2. ", "8. ", "9. ")

 

....

 

 

 I'll let you figure out the next expression. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
Amarendra
10 - Fireball

You can use a formula tool for your conditions and then filter based on the output. PFA,

Labels