Zero Values in Data for CrossTab

[alan_grn]

I have a table of Data which includes data with zero values..

When I use a crosstab load the zeros are removed. How do I retain them in the data?

[#2]

Hi,

Plz check the surpress zero values property in dimension tab

[#3]

check the option in  presentation tab >suppress zero values

[danieloberbilli · Accepted solution]

Use NULLASVALUE and Set NullValue (see below)

And try to load the data first as a normal table and then afterwards as crosstab

NULLASVALUE Field1,Field2,...;

Set NullValue = 0 ;

Source:

LOAD

     ID,

     Field1,

     Field2

FROM

xxx

CrossTable(attribute,data,1) LOAD * Resident test;

DROP Table Source;

[alan_grn]

Thanks. The trick was loading this again from the resident table.