How to input data UP UNTIL a specific (variable) row

Question

Hello,

I have a dataset the looks somewhat like the below. Data always starts on row 3 which is easy to configure in Input Data Tool.

Data also always ends right before row TOTAL, but that is always variable meaning in my example data ends in row 13 but it can be row 1,000 or 1,428 or 433,219 or really any number depending on how dataset is generated.

How can tell Alteryx to input data always starting at row 3 but up until one row before "TOTAL", whatever row number that is?

TimN · Accepted Answer

Something like this could work...

CoG · Accepted Answer

Unfortunately, there is no configuration item in the Input tool to accomplish your need. So you will have to filter after the fact. @TimN 's solution should work fine, as will this alternative, which is a little shorter: