load two separate table with same structure

Robert78 — Sat, 16 Nov 2024 18:59:59 GMT

Hello,

I need to load two separate table with almost same structure without synthetic table and without merging them.

I wrote this :

SQL
SELECT *
FROM "_BRO_CA_ONLINE";
STORE "_BRO_CA_ONLINE" into C:\QLICK\XX_BRO_CA_ONLINE.qvd(qvd);

SQL
SELECT *
FROM "_BRO_CA_ONLINE_facturi";
STORE "_BRO_CA_ONLINE" into C:\QLICK\XX_BRO_CA_ONLINE_facturi.qvd(qvd);

pls advice, thanks 🙂

Re: load two separate table with same structure

jochem_zw — Wed, 04 Mar 2020 18:20:32 GMT

You can use Qualify * statement

Robert78 — Thu, 05 Mar 2020 14:38:40 GMT

Thanks