topic Re: How get Missing table Information ? in QlikView

How get Missing table Information ?

madhubabum — Thu, 24 Sep 2015 06:52:36 GMT

Hi Experts

How to Get missing Table Information ?

Please Find Attached Sample Files and Application.

How We can achieve this one ?

Thanks

Re: How get Missing table Information ?

datanibbler — Thu, 24 Sep 2015 06:57:03 GMT

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

Re: How get Missing table Information ?

pokassov — Thu, 24 Sep 2015 07:02:41 GMT

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;

Re: How get Missing table Information ?

madhubabum — Thu, 24 Sep 2015 07:14:35 GMT

Hi Sergey Pokasov

Thanks for you reply

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

What is 'Employee' ?

Re: How get Missing table Information ?

pokassov — Thu, 24 Sep 2015 07:18:10 GMT

It's a table's name.

Re: How get Missing table Information ?

marcus_sommer — Thu, 24 Sep 2015 15:23:18 GMT

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

- Marcus

Re: How get Missing table Information ?

madhubabum — Thu, 24 Sep 2015 16:03:24 GMT

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.

Re: How get Missing table Information ?

madhubabum — Sat, 26 Sep 2015 07:07:19 GMT

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