Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I am doing a crosstable load and it is working fine.. but I am getting may $Orphan tables...
how to fix those..
Thanks in advance.
AA
hi,
try a quick fix using where 1=1:
crosstable(asdf,tet)
load
...
...
from table
where 1=1;
HTH
Sushil
hi,
try a quick fix using where 1=1:
crosstable(asdf,tet)
load
...
...
from table
where 1=1;
HTH
Sushil
Hi there,
This is an odd issue, and I presume it is happening due to the load from QVD being optimised and this loading the table model in first. The 1=1 would break the optimised load causing it to be parsed differently.
Typically you would not need to do a CROSSTABLE on a QVD, as this should be done when loading from the source data rather than from the QVD.
Steve