Why i am getting $orphan table while doing crosstable load

[Anonymous]

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

[sushil353 · Accepted solution]

hi,

try a quick fix using where 1=1:

crosstable(asdf,tet)

load

...

...

from table

where 1=1;

HTH

Sushil

[stevedark]

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