I think you should use OE_NR_2 with a samll difference.
This field will have a default value when OE_NR is null. You can achieve this during load with the following line
Load OE_NR, if( isnull (OE), 'N/A', OE) AS OE_NR_2
Then, all the users must be associated with this second (default) value (every users will have a second line in the section access).
Your section access would look like this:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OE_NR_2
ADMIN, A, A, A
ADMIN, B, B, B
ADMIN, A, A, N/A
ADMIN, B, B, N/A
Hope this helps,
That was a push in the right direction. This however only solves the problem partial, as now only the persons that have a mobile number, but no OE show up with OE N/A.
There are still phone numbers without person linked to them. And those still come up withouot an OE.
I've already tried the isnull on the PERS_NR in table 2, but without luck and also tried an if(len(PERS_NR) = 0, , )
OK, I've managed to get this working. I don't think it will win a beauty contest, but maybe you guys can explain why this is working and the before mentioned isn't.
What I did:
1. Left join table 1 and 2 and name this as a temp table.
2. Resident load the temp table and in the resident load performed the if(isnull(PERS_NR), '0000', PERS_NR)
3. Create an inline table with the same name as table 3 with the value of PERS_NR = '0000', OE = '0000'
4. Create an inline table with the same name as table 4 with the value of OE = '0000'
If someone could explain another (better/neater) way to achieve what I did here I'd be very gratefull.