Solved! Go to Solution.
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.
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
Hi Sean,
Thanks for letting me know. This has been resolved now. The above solutions mentioned were helpful to resolve.
Thanks
Evelyn