We have a daily export of 8 excel files that are placed in a sub-folder for that date. My top level folder is "Reports_Inbound" and it has a sub-folder for each day named "ROADS_Reports_yyyy_mm_dd" and then the files (ex. named "Actuals_Airlinr_Stats_Export.xlsx").
I want to import only the most recent Actuals_Airline_Stats_Export_yyyy_mm_dd.xlsx. Using the Import Wozard, when I select the top level folder it does not find the excel files in the sub-folders. How can I identify this to import the correct excel file?
Only the files in the chosen folder will be considered, not files in the sub-folders. For your use case, the best solution at this point will be to create more import steps in one transaction, each step for one sub-folder.
Also if you are using automation for this you can use a variable in the folder path. I will see if I can work up an example for you...
Julie,
This sounds like what I need. I would appreciate an example.
Here you go! At the top of the Automation I set a DATE variable and then in the import step I use that variable in the file path
Thanks foir the example, I see how it works for getting the import .TIM file with a current date, but what I need is the excel file being imported to use those variables. Below is what I see when I selected the excel fiel from 9/23/24 to import.
This is what the files to be imported look like in the directory.
The date on the file is a little more difficult because you cannot use the #variable# feature in the import template. You can create a copy step in automation that does use the #variable# to find the file with the correct date and copy it to a file name without the date on it and the import template can be setup to look for the filename without the date. Does that make sense or would you like to me do a few screen shots?
That makes sense. When I drilled into the data I found that it is formatted with the month/year in the columns, requiring the ability to unpivot some of the columns. I have not been able to find any such capability within TOAD, so I guess this will have to be handled outside of Toad.
The data looks like this:
Location | Description | Jan-2024 | Feb-24| Mar-2024|…
Terminal A Jet Fuel A (gal) 844 1458 504
Terminal A Jet Fuel A ($) $14878 $20485 $9874
Terminal A Unlead (gal) 687 478 248
Terminal A Unlead ($) $3048 $1986 $845
Terminal A Fuel Gals 1531 1936 752
Terminal A Fuel Sales $#### $#### $####