This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hi guys,
Hope that you're all doing well!
I have a bunch of excel files that I want to add to my workflow 1 by 1. I am inputting them in a batch macro however I am running into an issue, some files have unneeded rows at the start as seen below (this is not the actual data)
Some files have 4 rows and some have 3 and others do not have any unneeded rows.
My question is, is there anyway where I could automatically detect these rows for all the files and skip them to start from the data I want?
I was thinking maybe we could use the functionality of COUNTA on Excel if it can be mirrored on Alteryx.
Any suggestion is welcome.
Thanks a bunch!
Solved! Go to Solution.
Hi @Faresghnaim
I'm sure we can figure out a systematic way to determine how many rows should be skipped. In the attached example, I relied on the identity that the first field, [Field1], would be empty for the rows I wanted to skip. Once a non-empty [FIeld1] was found, I include all subsequent rows. This expression was built into a Multi Row Formula tool, then a Filter tool removed the unneeded records.
Check it out and let me know if this helps.
Thank you very much @CharlieS this was extremely helpful!