Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

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