Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Check before load

Hi ,

Is it possible to check and not to load a sheet in excel file which is not existing ?

I have a situation in which in one excel file have couple of sheets. First and second sheets are on monthly bases, but third is on quarterly base. I would like to load first two and check if third is existing . If not skip and load other sheets, if exist load all.

I attach a sample excel file.

Thanks in advance

Tags (2)
2 Replies
Honored Contributor

Re: Check before load

MVP & Luminary
MVP & Luminary

Re: Check before load


Please check below link

Load all Excel files and all sheets in a folder