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.
