topic Check before load in QlikView

Check before load

Mon, 23 Nov 2015 11:20:22 GMT

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

Re: Check before load

Siva_Sankar — Tue, 24 Nov 2015 01:58:21 GMT

Refer excel sheet name

Re: Check before load

jagan — Tue, 24 Nov 2015 02:55:59 GMT

HI,

Please check below link

Load all Excel files and all sheets in a folder

Regards,

jagan.