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

      puwo