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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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