Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I normally use applymap but now isn't working. I want to do the same as the third option of the apply map.
If the key match the field and if not 'missing' or whatever
How can i do that?
thanks
After left joining, you will need to use an if statement in your resident load
Table1:
LOAD Key,
....
FROM ...
Left Join (Table1)
Dim1
FROM ...;
FinalTable:
If(Len(Trim(Dim1)) = 0, 'Missing', Dim1) as Dim1
Resident Table1;
DROP Table Table1;