topic Re: How to Findout the Error Details in Loop in QlikView

How to Findout the Error Details in Loop

madhubabum — Fri, 09 Oct 2015 07:10:55 GMT

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 — Fri, 09 Oct 2015 07:24:13 GMT

Hi There,

try this,

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

HTH

Sreeni

avinashelite — Fri, 09 Oct 2015 07:25:23 GMT

check this :

SreeniJD — Fri, 09 Oct 2015 07:45:54 GMT

Hi Madhu

Refer this

Sreeni