Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a request
test1 : select from many tables and with join and where and group by i want to store the result of this request in a another table .
i tried :
test2:
load * from test1 and it doesn't work .
how can i handle it
hi,
you need to use word resident:
test:
Load * from xyz;
test2:
Load * from pqr ;
join (test2)
load * resident test ;
drop table test;
STORE test2 INTO 'lib://QVdata/test2.qvd' (qvd);
or
STORE test2 INTO 'lib://QVdata/test2.qvd' (CSV); in case you wanted to store into CSV format.
Vikas