4 Replies Latest reply: Mar 17, 2014 11:17 AM by Manoj Kulkarni RSS

    change value with if statement

      Hello together,


      I have 2 Tables <Items> and <Pflichtartikel>


      When I load the table <Items> it should compare, if the ITEMID exist in the table <Pflichtartikel>.

      If so, then the Value NULL should be changed to the value of the ItemId.

      The result should look like


      ItemId       pflicht

      CDR    URA

      Tinte    <null>

      Toner  <null>

      USB-Stick URA-1

      Festplatte <null>

      PC        <null>

      DVD     URA

      URA     URA

      URA-1  URA-1


      Thanks fo help