Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

how to find missing table information ?

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 ?

Labels (1)
6 Replies
marcus_sommer
MVP
MVP

It's already included - what is unclear?

how to skip a Excel Workbook ?

- Marcus

madhubabum
Creator
Creator
Author

Hi Marcus

Thanks for your reply,

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

Output : Sheet 2 (like that)

marcus_sommer
MVP
MVP

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

ganeshreddy
Creator III
Creator III

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

marcus_sommer
MVP
MVP

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

- Marcus

ganeshreddy
Creator III
Creator III

Thank you.