if null not working

[cwitman1]

Approval Table Loaded Table

Computer Name	EmployeeID	Access Level
A100	1234	Admin
B100	3456	Admin
C100	3667	Admin

Access Table Load table

Computer Name	EmployeeID
A100	1234
B100	3456
C100	3667
D100	1567

Access Validation (In App Join Table)

Computer Name	EmployeeID	Access Level
A100	1234	Admin
B100	3456	Admin
C100	3667	Admin
D100	1567

The problem is I want the null access level fields to say 'no approval' so i can filter by this.

I have tried if(isnull([Access Level]), 'No approval', [Access Level].  This does not work.

[sunny_talwar · Accepted solution]

Are you doing this after the join has taken place (in a resident load)? If not, then that's where you need to do this....

Approval_Temp:

LOAD [Computer Name],

     EmployeeID,

     [Access level]

FROM ....;

Join (Approval_Temp)

LOAD [Computer Name],

     EmployeeID

FROM .....;

Approval:

LOAD [Computer Name],

     EmployeeID

     If(Len(Trim([Access level])) > 0, [Access level], 'No Approval') as [Access level]

Resident Approval_Temp;

DROP Table Approval_Temp;

[stigchel]

Try with

if(Len(Trim(([Access Level])))=0, 'No approval', [Access Level]