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

Delete Rows Between Same String Value

Thordust16
7 - Meteor

Howdy,

 

I'm trying to delete rows between two same string values and delete empty lines more than 1. But I couldn't find a proper tool to perform that. 

I tried Record ID tool but the position of this string value changes for every file.

 

Below is the sample text 

 

Thordust16_0-1580918931933.png

3 REPLIES 3
Blake
12 - Quasar

Hi @Thordust16, I'd like to help you with your solution but I don't quite understand your question. Can you mock up what you'd like your data to look like after you run it through Alteryx? 

Thordust16
7 - Meteor

Hi Blake 

Thanks for replying.

 

Below is the desired output.

 

Thordust16_0-1580921647944.png

Blake
12 - Quasar

Let me know if the attached workflow works for you. 

Labels
Top Solution Authors