Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Exception output

ashriva2
6 - Meteoroid

Hi

 

I have a data which has 312 line item to validate, with the help of “filter tool”309 are valid exceptions and 3 three are actual exception on which I have to work. In the output file I need these 3 line item tagged as “Research” and 309 as “Valid exceptions”.

2 REPLIES 2
cjaneczko
13 - Pulsar

 

 

Use a formula instead of a filter. In the formula tool Use an IF statement with the criteria used in your filter tool. If those 3 records match the criteria set the THEN statement to "Research", ELSE "Valid Exceptions".

IF [FIELD BEING TESTED] = (Criteria for 3 fields to be triggered) THEN 'Research' ELSE 'Valid Exceptions' ENDIF
Towers
11 - Bolide

Hi @ashriva2,

This formula should work for you, I have attached an example for you.

Screenshot 2023-08-07 133919.png

Labels
Top Solution Authors