Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Solucionei usando um if NoOfRows antes de realizar o store da tabela..
Obrigada
Patricia
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
Solucionei usando um if NoOfRows antes de realizar o store da tabela..
Obrigada
Patricia