Display field that have no data

Sun, 18 Sep 2016 05:34:04 GMT

Hi All,

I have one field. But not all field got value. How can I display the field in dimension of pivot/straight table.

I want to show the fields even though there is no data on it.

Thanks.

Re: Display field that have no data

swuehl — Sun, 18 Sep 2016 20:26:42 GMT

Could you post some sample records and the result you want to achieve in your chart table?

I assume the field does not show a value in all records, so you have some NULL in your data.

Maybe test for NULL in your load script and set the value of these records:

LOAD

If(Len(Trim(FIELD)), FIELD, 'Dummy') as FIELD,

...