Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
if(IsNull(LEID),'Missing','Available')
Could you just display them differently in the Presentation tab?