topic Re: Application should still run if the table is missing in existing script in App Development

Application should still run if the table is missing in existing script

SatyaPaleti — Mon, 25 Apr 2022 18:33:36 GMT

Hi Experts,

We have a requirement. we were loading 5 to 6 tables. for example

table1.qvd,

table2.qvd

table3.qvd

table4.qvd

table5.qvd

Generally there will be a script error if any table got missing. we will get table not found error. but we have to ignore that error. Application should still run even though if any table is missing.

for example if table4.qvd is missing then it should not through an error. load should continue

can some one please do let me know how can it will be resolved

Thanks,

Satya

Re: Application should still run if the table is missing in existing script

Vegar — Mon, 25 Apr 2022 19:56:12 GMT

You could set ErrorMode =0 to ignore errors in script.

Take a look at this page: https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ErrorVariables/ErrorMode.htm

Re: Application should still run if the table is missing in existing script

Vegar — Mon, 25 Apr 2022 20:05:04 GMT

...or you can check if the file exists before attempting to use it.

if QvdCreateTime('lib://source/table1.qvd')>0 then

Load your data from lib://source/table1.qvd

end if