Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to incremental load latest excel file from folder.Excel files don't have Date field or key field to use where exists.Tried File list and wild card but no luck???
Thanks in advance
1. Don't do incremental loading, but load all the excel files with a buffered load statement. See the BUFFER prefix in the help file.
2. Move your daily excel file to another folder after reloading the qlikview document.
3. See this discussion: Re: Oldest Excel file LOADING. The title of the discussion is misleading. The OP wanted the newest excel file.