topic Re: Why i am getting $orphan table while doing crosstable load in QlikView

Why i am getting $orphan table while doing crosstable load

Anonymous — Sat, 13 Dec 2014 05:35:38 GMT

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.

Re: Why i am getting $orphan table while doing crosstable load

sushil353 — Sat, 13 Dec 2014 05:37:51 GMT

hi,

try a quick fix using where 1=1:

crosstable(asdf,tet)

load

...

from table

where 1=1;

HTH

Sushil

Re: Why i am getting $orphan table while doing crosstable load

stevedark — Wed, 24 Dec 2014 14:49:12 GMT

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