Dynamically deleting first rows based on condition

[andrewplaice]

I input data using wild card to pull in all the files from a location.  There may be 100+ files each day and up to this point the data I needed started on line 10.  That was easy enough to solve for.  

Recently, I was made aware of a new file (same columns) but data starts on line 8 and my workflow will blow up if this was the first file for the day.  I need my data to dynamically start where [f1] = “Specialist Name” and the sample tool is not that specific.  I started with a formula to tag a new column where [f1] = “Specialist Name” , but can’t figure out how to only delete the leading rows and not all of them.

Any ideas or other ideas for solving this?

[jacob_kahn · Accepted solution]

Hey @andrewplaice 

I love this question.

Check out the workflow I built and attached. You can also turn it into a Macro

please like and accept if this solution helps or assists!

[andrewplaice]

Sweet!  The Alteryx Community never fails to get me the answers I need.  Thanks for the quick and creative solution that gives me exactly what I want!  

[jacob_kahn]

@andrewplaice 

YAY!

Well I'll say that I think the Alteryx Community is my favorite part of the entire User Experience with Alteryx!