change field values

[#1]

I have 2 tables . One to many.

table A has field CUS_REF_ID, and table B has CUS_REF_ID and CUS_REF_NAME.

many values in table A has no values in table B. so the CUS_REF_ID is null.

When displaying table A as a chart choosing CUS_REF_NAME, the values in table A which is null CUS_REF_ID appears as "-".

Can I change this value to something readable not "-".

[jagan]

Hi,

Try like this

CUSTOMER:

MAPPING LOAD

     CUS_REF_ID,

     CUS_REF_NAME

From TableName

Where Exists (CUS_REF_ID);

[MAIN TALE]:

LOAD

     CUS_REF_ID,

     ApplyMap('CUSTOMER',CUS_REF_ID, 'Unregistered Customer') AS CUS_REF_NAME,

     Field2,

     Field3.....

From TableName;

Hope this helps you.

Regards,

Jagan.

[SunilChauhan]

see the attched file

please write  "Unresgister Customer" in place of - in attched screen

i.e Chart properties-> presentation ->null smbol-> Unregister Customer

...........................................Missing Symbol---->Unregister Customer