How is SAP unassigned i.e. # data read by QV?

[avastani]

I have lots of data in a field that is unassigned i.e. not blank, not null. SAP infuses # for it. how is it recognized in QV because it does not see #.

I tried '' (blank i.e. empty string) IsNULL and none worked.

Any ideas? Thanks.

[#2]

I had the same issue with some data unassigned.

Here's what I did....Chart Properties...Presentation Tab and change the Null & Missing Symbol to let say 'NA'.

Regards

Eraaj

[avastani]

That is at runtime level. how about at design time in the script?

do i ask for NA as well?

[#4]

"NullAsValue" statement can be applied @ scripting time.

Regards

Eraaj

[avastani]

so you mean to say LOAD IF(someField = 'NullAsValue', 1, 0) AS myField FROM some.qvd; will do the trick? I doubt because that makes it a string, doesn't it?

Amir.

[#6]

Hi Amir,

I believe you should not use NullasValue in if statement . It should be as below and this statement should be below the set statements.

set NullValue='<NULL>';

NullasValue Fieldname1,Fieldname2;

- Sridhar