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