Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Dynamically loading Excel sheets?

Hi Everyone,

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.

Thanks

0 Replies