Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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?

1 Solution

Accepted Solutions
Not applicable

Re: Save qvd

Use if NoOfRows before store table

Patricia

2 Replies
giakoum
Honored Contributor II

Re: Save qvd

if TbA and TbB etc have the same columns, QV will auto concatenate them into only one table.

Not applicable

Re: Save qvd

Use if NoOfRows before store table

Patricia

Community Browser