Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Keep only Required Row items and Discard the rest

DataPirate26
10 - Fireball

Below Attached is a Sample Data. I want to Update the Keep/Discard Field. The Record from where it Starts with Keep to the Record where it Ends with Keep needs to be updated with the Value Keep rest all needs to be discard. Can anyone help me with this ? 

3 REPLIES 3
DataPirate26
10 - Fireball

@binuacs Any approach on this ?

 

Christina_H
14 - Magnetar

So there are two rows labelled Keep and you want to keep everything in between?

Christina_H_0-1687338045487.png

 

DataPirate26
10 - Fireball

@Christina_H Thanx for the solution. 

Labels
Top Solution Authors