topic Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet?? in QlikView

How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

Wed, 23 Sep 2015 06:10:06 GMT

Hi All,

FOR Each File in FileList('$(vPath)*.xlsx')

ab:

Load Field1,

Field2,

Field3,

Field4,

Field5

FROM

(ooxml, embedded labels, header is 5 lines, table is [Output Tracker]);

next File

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.

Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

SreeniJD — Wed, 23 Sep 2015 06:25:17 GMT

Hi Vasudha,

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.

Regards,

Sreeni

Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

Wed, 23 Sep 2015 07:28:52 GMT

hi jaaldurgam‌

Thanks for your reply.

Here i am attaching qvw.Please review it as according to you.

Regards,

Vasudha

Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

Wed, 23 Sep 2015 07:41:18 GMT

jaaldurgam‌

FYI,

I am also attaching a screen shot of excel.Please go through it.

Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

SreeniJD — Wed, 23 Sep 2015 07:48:08 GMT

Vasudha - Attachments are missing, can you please re-attach the same.

Thanks,

Sreeni

Re: How can i track the specific sheet exist in a table or not and count the total number of rows in that sheet??

Wed, 23 Sep 2015 08:07:40 GMT

jaaldurgam‌

FYI,

Regards,

Vasudha