1 Reply Latest reply: Jul 26, 2013 4:25 PM by mayilvahanan ramasamy RSS

    Replace value if another table value exists?

    David Koschei

      FactTable:

      IDAmount
      125
      230

       

      DimTable:

      ID

      Type
      1A
      1B

      2

      A
      2C

       

      In the script, I want to replace Amount with 0 if any of its types are B, else leave it alone, resulting in:

       

      NewTable:

      IDAmount
      10
      230

       

      How can I do this?