Forum Discussion
Navigation Step in the Query Editor
Hello, When I click on the icon next to the Navigation step, the Navigation window opens. I thought it was used to select a table that had not been imported, so that you could view the data. ...
Yes! I had not checked there and sure enough, that should work. It was throwing me off that the formula bar only showed the last step of the navigation. But the Advanced Editor has all the steps.
Additionally, any chance you know how to have the navigation find the latest folder (the records are stored daily under a folder hiearchy that includes the year, month (number), and day. Any way to automate the navigation to always go to the latest date and get that file?
If you get files from a folder, you get a navigation table with the following columns:
| Content |
| Name |
| Extension |
| Date accessed |
| Date modified |
| Date created |
| Attributes |
| Folder Path |
The way to go is to filter this table somehow that will give you the desired file(s).
Thanks for the tip, that could be useful. Will try getting the folder with latest DateCreated.