Mapping Null values not working

[sajad_manzoor]

Hi,

I have following code:

//===========================================================================

TimeSheet:

SQL  SELECT

    "Entry No_",

    "Activity Code",

    "Consultant Code",

     EVPM,

    isNull("Man Days",0) as "Project ManDays",

     Month,

    "Working Date",

    "Project Code",

     Year

FROM ProjectManagement.dbo."PROJECT MANAGEMENT$Time Sheet Entry";

//=====================================================================================

ManDays:

SQL SELECT

    SUM("Man Days") as ManDays,

    Month,

    Year,

   "Consultant Code" 

FROM ProjectManagement.dbo."PROJECT MANAGEMENT$Time Sheet Entry"

Group By

      Month,

      Year,

     "Consultant Code";

//===============================================================================

Map_Nulls:

Mapping LOAD

Null(), '000' AutoGenerate ;

MAP EVPM USING Map_Nulls;

TimeSheet2:

NoConcatenate 

LOAD * RESIDENT TimeSheet;

DROP TABLE TimeSheet; 

I want to remove null values in EVPM,

But the above null mapping does not work at all,

please suggest 

[kaushiknsolanki · Accepted solution]

Hi,

The

     code which i have told you is used when you want to replace the null with some values.

     Son in your code you can try this.

      NullAsValue EVPM;

     Set NullValue = '0' ;

     SQL Select *

     FROM ProjectManagement.dbo."PROJECT MANAGEMENT$Time Sheet Entry";

Regards,

Kaushik Solanki