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: 
Not applicable

Save qvd

I have a list of 197 tables and I need to compare the different records.
I'm using the command


TbA:
(select col_a, col_b, col_c
   from tab_1
union all
select col_a, col_b, col_c
   from tab_2)
minus
(select col_a, col_b, col_c
   from tab_1
intersect
select col_a, col_b, col_c
   from tab_2)


TbB:
(select col_a, col_b, col_c
   from tab_3
union all
select col_a, col_b, col_c
   from tab_4)
minus
(select col_a, col_b, col_c
   from tab_3
intersect
select col_a, col_b, col_c
   from tab_4)

etc...

When recording the QVD want it saved just Tb have different records, in the amount of TBA records read is 0 QVD not save ...
Can anyone help?

Labels (3)
1 Solution

Accepted Solutions
Not applicable
Author

Solucionei usando um if NoOfRows antes de realizar o store da tabela..

Obrigada

Patricia

View solution in original post

2 Replies
nicolett_yuri
Partner Ambassador/MVP
Partner Ambassador/MVP

Acredito que você possa utilizar o Generic Load para resolver isso.

Da uma olhada nesse post: http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Not applicable
Author

Solucionei usando um if NoOfRows antes de realizar o store da tabela..

Obrigada

Patricia