Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Give different alias name for calendar_date and convert it from string to date in each record set and try again.
write in both table Date(calendar_date,'MM/DD/YYYY')AS calendar_date
instead of simply write calendar_date