How to Findout the Error Details in Loop - Qlik Community

madhubabum · ‎2015-10-09

HI Experts

I am having the Excel files in a folder , Here i am loading all the Excel files in a loop .

Here , i am getting the No Error & Missing Field Information.

But , I want to display Error of Table Not Found (If Particular Table not found , Display the Missing Table Name )

Here i am attaching the sample Excel files and application .

Note :

Book1 : No Error

Book2 : No Error

Book3 : Table Not Found

Book4 : Field Not Found

Note : Only Qlikview Generated Errors (with out hard coding)

How we can Achieve this one ?

Thanks

Madhu

SreeniJD · ‎2015-10-09

Hi There,

try this,

$(Must_Include =filename) this will throw an error if the file is not available.

HTH

Sreeni

avinashelite · ‎2015-10-09

check this :

SreeniJD · ‎2015-10-09

Hi Madhu

Refer this

Sreeni