3 Replies Latest reply on Jan 14, 2014 10:34 AM by KK Molugu

    How to set a field to 0 when data cannot be found in secondary data source during blending?

    Peter Sabela

      Example of the result of data blending:

       

      ACCOUNT     SOURCE1_AMT     SOURCE2_AMT

      1111111          $150.00              

       

      I need the SOURCE2_AMT to default to 0 when data blending does not find this account.  This is so I could calculate the difference.