14 Replies Latest reply: Jul 27, 2016 7:40 PM by Iskander Smagulov RSS

    Take a value from one row and put into another

    Iskander Smagulov

      Hi guys!

       

      Very interesting question, I couldn't find the answer in google yet. Please help or give an advice.

       

      The situation:

      I have table 1

      StoreItemAvailableChecked

      S1

      I10*
      S2I10*
      S3I12
      S4I10*
      S5I10
      TI12

       

      The task is to take Available values from store T and spread it into other Checked stores. It should spread only 1 item for each necessary store.

       

      Finally table would look like:

      StoreItemAvailableCheckedFinally

      S1

      I10*1
      S2I10*1
      S3I122
      S4I10*0
      S5I100
      TI120

       

      Also please help to make new row where I could write from which store I took item and where I put this item.