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.
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.
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.