Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Automatically skip unneeded rows and set headers

Highlighted
7 - Meteor

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)

 

Faresghnaim_1-1584540021687.png

 

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!

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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. 

Highlighted
7 - Meteor

Thank you very much @CharlieS  this was extremely helpful!

Labels