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 "-".

[NareshGuntur]

Hi Ayman,

Go to Properties ---> Presentation tab

Left side bottom, you have an option to replace the null value with value you wish.

Cheers,

Naresh

[#3]

In script you can give like this

B:

load

CUS_REF_NAME,

if(CUS_REF_NAME<>'' and CUS_REF_ID='' ,'Novalue',CUS_REF_ID) as CUS_REF_ID

from[]

Hope it will help.....

[#4]

I can't find it.

I have only option Omit Rows where Field is NULL.

but no option to change the value

[mdmukramali]

Dear ,

kindly find the attached.

I hope it will help you.

Thanks,

Mukram.

[#6]

Sorry but I think I need to explain more about the relation between the table.

Table A

Field:    A_DB_ID.

Table B.

       A_DB_ID

       NAME_DB_ID

Table C   

         NAME_DB_ID

         NAME.

so the relation is

       select A.A_DB_ID, C_.NAME from A,

                     (select NAME,A_DB_ID from B,C where B.NAME_DB_ID = C.NAME_DB_ID) C_

       where A.A_DB_ID  = C_.A_DB_ID.

[#7]

I am able to in Straight table, but I need to change the NULL values in the CHARTS

[mdmukramali]

Dear ,

kindly find the attached file.

[MK_QSL]

Dear Ayman,

If CUS_REF_ID don't have data in your Fact/Main/Transaction Table and if you want to load only those CUS_REF_ID having some data, you can use as below

1) First Load your Main or Fact or Transaction Table

[MAIN TALE]:

LOAD

     CUST_REF_ID,

     Field2,

     Field3.....

From TableName;

2) Now Load your CUS_REF_ID Table

CUSTOMER:

LOAD

     CUS_REF_ID,

     CUS_REF_NAME

From TableName

Where Exists (CUS_REF_ID);

This will restrict CUS_REF_NAME having no records in main table to load

Hope this helps..

[#10]

Thankx Manish,

But I need these values. I just want to change the null value something like.

"Unregistered Customer"