Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Can any one help me on the below scenario plz asap..
I have 20 excel files to load the data, I have used 'ErrorMode = 0' to skip the files which is having wrong header name,
but in log file I can see that which file was not loaded and Error occurred while loading,
But I need to capture that error details, and se send the error details as alert mail to users, which describes that what ever the files were not loaded..
My script like below:
For each file in filelist ('C:\Data\*.xlsx')
ErrorMode = 0;
Tab1:
Load A1,
B1,
C1,
D1
From
[$(File)] (ooxml, Embededlables, Header lines 2)
Next File;
You can use the ScriptError and ScriptErrorDetails variables. See this document: ErrorHandling in Qlikview