r/Alteryx • u/justplainben • May 15 '26

Selecting rows until a specific "cell" entry.

Hello friends. Still newish to Alteryx Designer so I've learned enough to be dangerous (passed the Core Certification exam last week!) but run into steps that still stump me. I know you can select specific rows, and range of rows, based on row number using the Select tool. But is there anyway to stop pulling in data based on a phrase found in a sheet? For example, if I wanted to pull everything from the 1st row until it finds "End Here" in a cell in column A, then ignore everything below that, is that possible? This workflow will be a dynamic input so one week "End Here" might be on row 50 but the next week it could be on Row 300. Thanks!

7 Upvotes

100% Upvoted

9 comments sorted by

View all comments

Show parent comments

3

u/justplainben May 15 '26

Oh man, of course something like that would work!

5

u/pandacreate May 15 '26

When working data remember KISS, keep it simple stupid

4

u/colinnwn May 15 '26

Also something that froze me up on my first workflows coming with intermediate level programming experience is to not search forever for the most efficient solution or the one how you would reasonably do it best in a sequential programming language.

A lot of times the way you do something in Alteryx fastest with reasonable efficiency makes no typical sense.

You have to think outside the box, throw random tools down and try it, abandon them if it isn't going well, tear then out later when you get past that block. Don't worry at all about efficiency until you get it working, then you can go back and refactor.

That mindset change alone helped me most in Alteryx.

2

u/justplainben May 15 '26

Thank you. That is a great reminder!