Remove Totals Row When Inputting Data

robertfishel

Hello Alteryx Community!  I have a canned report that is ran daily and which gives a data set as it's result.  I am trying to input this data set into my workflow.  The data set has 6 rows of header information, which I have bypassed by selecting "Start Data Import on Line" 7.  However, the data set also has a row at the very bottom, in which every cell along the row except two is empty.  Two cells have totals.  I want to skip over this row as well when importing my data.  Can this be done?

SamDesk

Hello @robertfishel,

While I'm not aware of a way to skip over this row at import, there is an easy solution to clean it post-import.

By assigning a RecordID to each record of the import, summarising to the maximum value of this record ID and then taking a left un-join where the RecordID equals Max_RecordID we can remove the final row from the import.

Hope this is helpful.

Sam

Remove Totals Row When Inputting Data.yxmd