โ06-11-2018 02:01 AM
Hi,
I am doing a lookup on a table and matching incoming column with lookup column. If that value is not present lookup did not return that column with null. It just doesnโt return that column at all.
I need to filter the record if that value is not found it lookup table. But not able to do so. Other than joining those tables, do you have any other approach.
โ06-11-2018 09:18 AM
You can use a mapper with the nullsafe option turned on, and specify the fields that you need on the source and target. That should give you a null value. You can also simply replace the source value with a string like:
((โLAST_NAMEโ in $)?$LAST_NAME: null)
This is basically two commands: