Crosstable --> $orphan

[#1]

Hi

I want to create a crosstable, I've done it but when I take a look with the table viewer every field looks like a separate table with the &orphan and the name of the table as a prefix.

This's how I've done it:

INVENTORY_FAILURE2:
QUALIFY *;
UNQUALIFY CO_PRODUCT;
CROSSTABLE(Failure, Veces, 7)
LOAD co_enterprise,
co_art AS CO_PRODUCT,
DATE,
date(DATE) as Fecha_Inv,
year(date(DATE)) as Anno_Inv,
month(date(DATE)) as Mes_Inv,
day(date(DATE)) as Dia_Inv,
FAILURE1,
FAILURE2,
FAILURE3,
FAILURE4,
FAILURE5
FROM QvD\INVENTORY_FAILURE.QVD (qvd);

What am I doing wrong???

Thxs in advance

[#2]

Thank you Bruno – it’s great to know I’ve helped someone on the community since it is my first stop for help when I am stuck.

Kathryn Brown

[kangaroomac]

Hi Brad,

Well done! It's quite ironic, because I've just had the same thing happening ("Too" optimized load) and a quick search resulted in your answer.

Now the irony (as you know) is that we were sitting in the same office at the time...

[#4]

Thank you Brad,

Greetings

[gallantabs]

Three years on and your solution worked wonders for me on qliksense. Thanks

[Dano]

Another solution is to use Resident Load rather than load data directly from QVD.

[neerajthakur]

But why does it get created in the first place? What's the reason and does where 1=1 affects it to display correctly.