I want to replace empty strings with null in the Application Integreation.
util:iif(SeatNumber="", null, SeatNumber)
So, if SeatNumber is some number then it will return that number, if seatnumber is empty then it should return null. But Informatica Application Integration is throwing error like "The expression depends on the context item"
Can anyone help
Please find the below working expression as null in itself doesn't mean much in this context.
util:iif(fn:empty($temp.untitled1), 'null',$temp.untitled1) where $temp.untitled1 can be replaced with the SeatNumber variable in your case.