Hello, I can't figure out how to reject row from input "ok" depending on the following rule : If ok.CPTFISAG doesn't begin with "4" then Reject each rows of input "ok" where there's no row for ok.CBUFISAG = lm_tSACBU1.BUASACBU Reject each rows of input "ok" where there's no row for ok.SVCFISAG = lm_tSASVC1.SVASASVC Reject each rows of input "ok" where there's no row for ok.CPTFISAG = lm_tSADES1.CPTSADES If I check inner join on lm_tSACBU1, lm_tSASVC1, lm_tSADES1, and Filter + Inner join Reject on the 3 output reject I got a NullPointer Exception 😞 This happens when ok.CBUFISAG has no lm_tSACBU1.BUASACBU or ok.SVCFISAG has no lm_tSASVC1.SVASASVC or ok.CPTFISAG has no lm_tSADES1.CPTSADES See screnshots. Thanks for helping, Didier
Hello alevy,
in fact Frais is a file and CATVA is a mySQL table that can contain null. So "Frais.TVAFIFRS.equals("")?null:Frais.TVAFIFRS" seems to be the good way to join the empty value of Frais.TVAFIFRS and the null value of CATVA.TV1CATVA :-)
Thanks again for your help !!!
