topic Re: how to find missing table information ? in QlikView

how to find missing table information ?

madhubabum — Wed, 23 Sep 2015 14:35:27 GMT

Hi Experts

I am Having Excel file with 3 tables (Sheet 1, Sheet 2, Sheet 3)

Note : Having Values for Sheet 1 & Sheet 3

I am already loaded sheet 1 & Sheet 3 data

But , I want to show the Missing table Information . How ?

Re: how to find missing table information ?

marcus_sommer — Wed, 23 Sep 2015 14:42:06 GMT

It's already included - what is unclear?

how to skip a Excel Workbook ?

- Marcus

Re: how to find missing table information ?

madhubabum — Wed, 23 Sep 2015 14:48:18 GMT

Hi Marcus

Thanks for your reply,

I want Missing Table Information Only ?(Which sheet is Missing )

Output : Sheet 2 (like that)

Re: how to find missing table information ?

marcus_sommer — Wed, 23 Sep 2015 14:57:02 GMT

You mean the file-informations then the sheet is in all files the same and this will be append to the origin data-table per concatenate-statement within the else-part from loop and could create a tablebox like this:

- Marcus

Re: how to find missing table information ?

ganeshreddy — Thu, 24 Sep 2015 07:12:39 GMT

Hi Marcus,

I am also looking for same result can you please add a QVW for the screen shoot which you have given for missing data and data. It would be very helpful to me.

Best Regards,

Ganesh

Re: how to find missing table information ?

marcus_sommer — Thu, 24 Sep 2015 07:37:32 GMT

This is attached in my last answer to how to skip a Excel Workbook ?

- Marcus

Re: how to find missing table information ?

ganeshreddy — Thu, 24 Sep 2015 10:47:35 GMT

Thank you.