Data Preparation/ Formatting - Excel file

Question

Hi ,

I am a beginer in Alteryx and I would like to know how to exclude the last three records in my excel file . Please note,the files I need to process has variable number of records each time. Would anyone help me how to do that in Alteryx?

Thanks
Evelyn

ToddW · Accepted Answer

If you want to exclude the last three records in your Excel file, you can use a combination of tools along with the Sample tool.

MargaritaW · Accepted Answer

Another way is using the Dynamic Input tool which has a SELECT TOP N * FROM Sheetname statement, the N gets replaced by the number of rows -3 which gets identified with the Count rows tool.

Ned · Accepted Answer

I wrote a macro to solve this for you and put it up in a blog post:

http://inspiringingenuity.net/2014/07/15/alteryx-skip-last-n-records/