suppress the null values in table box

[#1]

want to suppress the null in my object by using edit script

pfa

[Gysbert_Wassenaar]

Perhaps your data model isn't optimal. It's impossible to tell from the screenshot you attached.

Perhaps you should use a straight table object instead of a table box object with expressions for the last four columns like max(CAS_Updated_Date1) and maxstring(CAS_Value_Type1).

[alexandros17]

You cannot because the problem is related to data no to its visualization, you have 2 records each one with a value on a column only, you must normalize this situation.

Hope it helps

[Roop]

I would always tend to use a Chart with the expressions defined as those columns that I wished to use as a suppression mechanism - This means it can work according to how you want.

[#5]

Hi

Suneel,

may be It's not Null Value Issue It's Data Model Issue,Please Upload the Data  i can give u proper solutions either using left join concept. 

[#6]

Am using below but i din,t get  could u please me as  early as possible

Calender:

LOAD CAD_Activity_ID,

     CAS_Date_Value,

     CAM_ID,

     CAS_Remarks,

     CAS_Status,

     CAS_Updated_By,

     if (CAS_Value_Type='A', CAS_Updated_Date)as CAS_Updated_Date1,

     if (CAS_Value_Type='T', CAS_Updated_Date)as CAS_Updated_Date2,

    // if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,

     //if (CAS_Updated_Date = (CAS_Value_Type='T'), 'CAS_Updated_Date')as Date2,

     if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,

     if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,

     CAS_Version

FROM

(qvd);

Right join

cal:

LOAD CAD_Activity_ID,

     CAS_Date_Value,

     CAM_ID,

     CAS_Remarks,

    if(IsNull( CAS_Updated_Date1) ,0,CAS_Updated_Date1)as CAS_Updated_Date1 ,

    if(IsNull( CAS_Updated_Date2) ,0,CAS_Updated_Date2)as CAS_Updated_Date2,

     CAS_Value_Type1,

     CAS_Value_Type2

resident Calender

[bertdijks]

You can create a new table and select the max values, finnaly don't forget to drop the Original table!

Load Activity_ID,
     CAS_Date_Value,
     CAM_ID,
     CAS_Remarks,
     CAS_Status,
     CAS_Updated_By,
     max(CAS_Updated_Date1) as CAS_Updated_Date1,
max(CAS_Updated_Date2) as CAS_Updated_Date2,
     max(CAS_Value_Type1) as CAS_Value_Type1,
max(CAS_Value_Type2) as CAS_Value_Type2 ,
    CAS_Version
     resident Calender
     Group by Activity_ID,
     CAS_Date_Value,
     CAM_ID,
     CAS_Remarks,
     CAS_Status,
     CAS_Updated_By,
     CAS_Version;
 

     Drop table Calendar;