Alteryx Designer Discussions

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

Extracting rows from the dataset based on some condition

Ekta
8 - Asteroid

Hi Everyone, 

I am stuck at one place in my workflow, please help me with the formula for the below logic-

 

if Code for any student contains "QWE" and its only 1 record in the dataset then keep the record example for Student id 4

but if there are 2 codes for any student example Student ID 2 and Student ID 6 then only keep the row without "QWE"

Input data  -

Ekta_0-1612431488580.png

 

Required Output is 

Ekta_1-1612431736491.png

 

Please help me with this and very TIA

 

2 REPLIES 2
Assaf_m
11 - Bolide

Check the attached solution,

 

let me know if it works for you.

 

Assaf_m_0-1612432842918.png

 

afv2688
16 - Nebula
16 - Nebula

Hello @Ekta ,

 

I went a little bit overkill just in case there are 2 or more lines with the same student ID. 🙂

 

Untitled.png

 

Regards

Labels