Discussion board where members can get started with QlikView.
FOR Each File in FileList('$(vPath)*.xlsx')
(ooxml, embedded labels, header is 5 lines, table is [Output Tracker]);
ErrorLogTable: LOAD '$(ScriptError)') as Error, '$(ScriptErrorDetails)' as ErrorDetails, '$(#ScriptError)' as ErrorCode, '$(File)' as FilePath, FileTime() as ReloadTime, FileName() as FileName FROM '$(File)' (ooxml, embedded labels, header is 5 lines, table is [ Output Tracker]);
I have the above script in this i am fetching multiple data from multiple excels and storing their erros in the below error log file.I need to check every time that
1-whether above output Tracker sheet in the each table is exits there or not and want to capture sheet error in the error log table below if output tracker sheet does not exists.
2.And also want to know if sheet is blank /having null values.
3.i need to count the total number of rows in every excel.
how can i achieve the above requirements. Please any body let me know.
It seems there are some syntax issues in your script, can you pease share the sample qvw, I will correct it and will send it to you at the earliest.
Thanks for your reply.
Here i am attaching qvw.Please review it as according to you.
I am also attaching a screen shot of excel.Please go through it.
Vasudha - Attachments are missing, can you please re-attach the same.