3 Replies Latest reply: Jun 10, 2012 6:12 PM by ssha 324 RSS

Issue with a NULL value

ssha 324

Hi,

 

I am having an issue that I am unable to resolve and am hoping someone could help me.

In the attached document, Sup.qvw, On tab Sheet 10, when I  filter on Location Code ->OCDAM, I get [Resp Centre] values as NULL and  WAHAROA.

 

However, it should not be returning any NULL.

 

In the load script, on Transaction tab, when I comment out the script where  we concatenate the Sales Transaction table with TempSalesForecast table and  reload the script, the Location Code OCDAM returns only WAHAROA (which is  correct).

 

However, when I uncomment it, it seems to be returning both NULL and WAHAROA  for Location Code OCDAM. If I copy the LOAD statement commented out above into a  separate qvw (Test.qvw) and run it, it  seems to be returning only WAHAROA.

 

I dont understand where I am going wrong. I suspect its because of the mapping load I use to look up [Resp Centre] in the load script

 

Can someone plz help.