This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I use the skip 1st N rows in almost all my workflows and find that I have unwanted rows at the bottom of my data a lot and will end up having to sort the data before being able to skip the 1st N rows. It would be a lot easier to just skip the last N rows instead.
hi @alexlat11 thanks for your feedback. I'm not sure why this option wasn't included; perhaps it is because that same thing can be accomplished with the Select Records tool (which admittedly does not include the dynamic "%" option). We'll be sure to pass along your idea once the necessary criteria are met.
This is a request I was coming to make myself. This would be handy when dynamically pulling data from SAP via the DVW connector. Tables like MB51 or **bleep**LL03H pull in stuff at the bottom where adding the removal in the sample tool would be helpful (eg remove bottom 3 records always). I could see a dynamic option also being handy for others, less so for SAP pulls.
This would remove the need to reverse the row order, skip 1st N and reverse row order again in order to achieve this, which is not ideal, especially with large datasets.