Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Data Preparation/ Formatting - Excel file

evelyn_sherwin
6 - Meteoroid
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
6 REPLIES 6
ToddW
Alteryx Alumni (Retired)
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
Alteryx Alumni (Retired)

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.

rtaImage (19).png

rtaImage (20).png

 
Margarita Wilshire
Sr. Manager, Customer Support Engineering
Women & Allies Committee


Alteryx, Inc.
evelyn_sherwin
6 - Meteoroid
Thanks for those answers. When using the Dynamic input tool can you please explain what options I need to choose?
Ned
Founder
Founder
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/

 
SeanAdams
17 - Castor
17 - Castor

this is now also fully supported using the sample tool - just invert the sort order of your data, skip the first 3 rows, and then invert again.

 

@evelyn_sherwin- let me know if you still have questions (just reply with a workflow with some sample data) and we can crack through to help you solve, or if this is now solved would you mind tagging this as solved?

 

Cheers

Sean

evelyn_sherwin
6 - Meteoroid

Hi Sean,

Thanks for letting me know. This has been resolved now. The above solutions mentioned were helpful to resolve.

 

Thanks

Evelyn

Labels