Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I'm trying to figure out a code that works for incremental load based on the file name (which are just the dates when loaded). Let me explain. I have been running into some issue with loading time, when updating my app. My current loading set up I have is that the app is pulling from a folder that had has excel files that I name with the date. I receive files each week and I save it as the date in the folder, but now the folder had 40 reports and it take forever to load all the information in. I trying to figure out a way that i can pull only 12 files at a time and only the most recent one. Could anyone help? Thank you very much in advance.
Example of the file names
1.28.19,2.4.19,2.11.19,2.18.19,2.25.19 and etc
What are these numbers from file name?
The numbers are the date i save the file into the folder. Example: I receive a file Jan 28, 2019 so i save the file as 1.28.19. The excel file if you look into the folder would be 1.28.19