Map Load/Join Issue

[Anonymous]

Hi,

     I am trying to map the aggregated value to the actual result set for the month end value. We are trying to popualted agregated sum for month end date remainging days we want to populated with Unknown or 0 value.

  Here is the code:

map:

MAPPING LOAD  calendar_date,

         month_end_vehicle_tna  as month_end_sales

FROM

J:\tmp\Sapient\DataViz\EARPhase\3_QVD\Layer_2\AUM_Transformed_View_Agr.qvd

(qvd);

b:

LOAD

     calendar_date,

     month_end_date,

     Vehicle_TNA as sales,

     APPLYMAP('map', calendar_date,0) AS  month_end_sales_final

FROM

J:\tmp\Sapient\DataViz\EARPhase\3_QVD\Layer_2\Master_Calendar_Trn.qvd

(qvd)  ;

The issues is evethough we had calendar date (03/31/2011) present in both the record sets also it is showing uknown assets instead of showing the actual value .Attached the qvw file.

Thanks

Dasu.G

[#2]

Give different alias name for calendar_date and convert it from string to date in each record set and try again.

[er_mohit]

write in both table   Date(calendar_date,'MM/DD/YYYY')AS calendar_date

instead of simply write calendar_date