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 Ayman,
Go to Properties ---> Presentation tab
Left side bottom, you have an option to replace the null value with value you wish.
Cheers,
Naresh
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.....
I can't find it.
I have only option Omit Rows where Field is NULL.
but no option to change the value
Dear ,
kindly find the attached.
I hope it will help you.
Thanks,
Mukram.
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.
I am able to in Straight table, but I need to change the NULL values in the CHARTS
Dear ,
kindly find the attached file.
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..
Thankx Manish,
But I need these values. I just want to change the null value something like.
"Unregistered Customer"