QlikView Ignore If Sheet doesn't Exists

BarbouS_ — Wed, 02 Mar 2022 09:02:25 GMT

Hello guys, I have an issue:

I need to read 8 different excel files, but not all of them have 2 particular sheets , so in some of those files the sheets 'a' and the sheet 'b' are not present.

Is there a way to make Qlikview read all 8 excel files ignoring the fact that in some of them the sheets 'a' and 'b' are missing?

Without this I would need to get inside each file, check if the sheet 'a' and 'b' are present and If not create them, or QlikView will give me an Error.

Thanks in advance,

Arthur

Thanks in advance

Re: QlikView Ignore If Sheet doesn't Exists

marcus_sommer — Wed, 02 Mar 2022 12:18:44 GMT

One option would be to load the data per ODBC driver because then you could query the system-tables first to find out which sheets exists and then looping through them.

Another way would be to enable/disable ERRORMODE to continue the script-execution in the case of an error.

- Marcus

topic QlikView Ignore If Sheet doesn't Exists in QlikView

QlikView Ignore If Sheet doesn't Exists

Re: QlikView Ignore If Sheet doesn't Exists