Deleting Empty Rows at the top of the table

Question

Hi all, Here's my problem: I receive an Excel file from a business partner on a bi-weekly basis, which I transform using Alteryx into a format that I prefer. While the size and field names of the table is rather consistent, The number of empty rows at the top of the sheet varies. Is there an elegant way to get rid of the leading empty rows? The rows may not necessarily be fully empty, so I guess a safer bet would be to look for the field names in the first row of the table. Thanks in advance.

JoeS · Accepted Answer

As long as you know a header value that's always going to exist you can use something like:

If you plug your data in at the start, you'll then need to update the filter circled in red to look for what you need, the rest should work without being updated.

estherb47 · Accepted Answer

Hi @dhtay

If there are a few rows which will remain empty, you can filter on those.

In the Filter tool, set a custom filter to be:

!IsEmpty([F2])
OR
!IsEmpty([f3])

as many columns as needed to define the rows you want to skip, and then stream off of the T output.

You could also do the reverse, using IsEmpty([col1]) AND IsEmpty([col2]).... and stream off of the F output.

Let me know if that helps!

Cheers,

Esther