8 Replies Latest reply: Oct 21, 2015 5:39 AM by Eliza FILIP RSS

    Left Join with NULL on Script

    Eliza FILIP

      Hello Team,

       

      I have two tables join with left join, and the null values must be filled with calculated values.

      I tried to use the ISNULL () function and ALT() function, but without success.

      I think it's from setting, but do not understand where is my mistake.

      My desired result it is:

           

      F1F4ALTISNULLResult
      1100100100100
      2-1MISSING42290
      3-1MISSING42290

       

      See the file attached.

      Could you please help?

       

      Thank you in advance for help!