Replacing Null

[#1]

Hi

I have a Table like below :

AGENTID	LEID
1	TN31Q8429
2	-
3	-
4
5	TN31Q8433
6	TN31Q8434
7
8
9
10	TN31Q8438

I want to display a chart , if there is a value in LEIID , then its 'available' , if no value (Which includes -)'Missing'

How to achieve it

[VishalWaghole]

Hi,

Try this,

Test:

LOAD * Inline [

AGENTID,    LEID

1,    TN31Q8429

2,    -

3,  -

4,  -

5,    TN31Q8433

6,    TN31Q8434

7,  -

8,  -

9,  -

10, TN31Q8438

];

LOAD *,

     if(Match(LEID,'-'),'Missing','Available') as Flag

Resident Test;    

and also find attached application

-- Regards,

Vishal Waghole

[tresesco]

If you are talking about handling nothing(space or so) and '-' together, try like:

Test:
LOAD * Inline [
AGENTID, LEID
1, TN31Q8429
2, -
3,  -
4,  -
5, TN31Q8433
6, TN31Q8434
7, 
8, 
9, 
10, TN31Q8438
];

LOAD *,
  if(Match(LEID,'-') or Len(Trim(LEID))=0,'Missing','Available') as Flag
Resident Test; 

[Yousef_Amarneh]

     if(IsNull(LEID),'Missing','Available')

[c_gilbert]

Could you just display them differently in the Presentation tab?