Discussion Board for collaboration on QlikView Scripting.
I have a requirement where we need to load sheet n excel files dynamically.
For 2016 file we have sheet names like Jan, feb ..... dec
For 2017 file we have sheet names like Jan, feb ..... dec
but in 2018 sheets names are only from Jan to Aug and next month we will receive Sep.
Qlik is loading fine till 2018 Aug, but it gives error since Sept file is not available.
Can anyone please help me to load files incrementally with all sheets.