Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 "-".
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.
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