How get Missing table Information ?

[madhubabum]

Hi Experts

How to Get missing Table Information ?

Please Find Attached Sample Files and Application.

How We can achieve this one ?

Thanks

[datanibbler]

Hi madhu babu,

can you elaborate a bit on what type of missing information you are looking for? Fields which are not populated?

The ISTEXT() or ISNUM() or LEN() or ISNULL() functions might prove helpful in that case.

HTH

[pokassov]

Hi!

FOR Each File in FileList('C:\1\*.xlsx')

let vRowsBefore=NoOfRows('Employee');

Employee:

LOAD EmpId,

     EmpName,

     EmpType,

     Sal

FROM

'$(File)'(ooxml, embedded labels, table is EmpDetails);

let vRowsAfter=NoOfRows('Employee');

if vRowsBefore=vRowsAfter then

Error:

  load

  '$(File)' As File,

  'Field Values Not Found' As DetailErr

  AutoGenerate (1);

end if;

ErrorQvd:

LOAD

FileName() as FileName,

'$(File)' as FilePath,

if(len('$(ScriptErrorDetails)')=0,'No Error','$(ScriptErrorDetails)') as ErrorDetails,

ReloadTime() as [Reloaded Date and Time]

FROM

'$(File)'(ooxml, embedded labels, table is EmpDetails);

next File

SET Errormode=1;

[madhubabum]

Hi  Sergey Pokasov

Thanks for you reply

Note :    let vRowsAfter=NoOfRows('Employee');

What is 'Employee' ?

[pokassov]

It's a table's name.

[marcus_sommer]

What's left unclear here: how to skip a Excel Workbook ? and here: how to find missing table information ?

- Marcus

[madhubabum]

Hi Marcus Sommer

I want Missing Error Field Details , as following

Note : These values must and should associate to the Error_Files

Please find attached Application.

[madhubabum]

Hi Sergey Pokasov

Thanks For giving Solution, but i need one more information to add to Error table i.e Missing EmpDetails from file  i.e We are using other Excel file With out EmpDetails Sheet (Blank file with EmpDetails Missing), We need this as Missing EmpDetails sheet  in file.

How to Achieve this  ?

Thanks

Madhu