topic Re: Save qvd in Brasil

Save qvd

Fri, 02 May 2014 14:57:33 GMT

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?

Re: Save qvd

nicolett_yuri — Fri, 02 May 2014 21:26:12 GMT

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

Re: Save qvd

Wed, 07 May 2014 16:48:22 GMT

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

Obrigada

Patricia