2 Replies Latest reply: Mar 29, 2016 8:09 AM by Gysbert Wassenaar RSS

    Variables in the data load editor with conditions

    KENNETH ANDERSEN

      Datafile:

      Udklip.JPG

       

      I like to calculate some variables when loading my data but I'm not sure how to deal with the the syntax.

       

      (I've LOTS OF variables to calculate and like to do it when loading data instead of calculate on the fly using expressions)

       

      1) I like to create a variable called 'G1' which should sum Product AB01 combined with Salespoint 1200 (In this case result = 3)

       

      2) I like to create a variable called 'G2' which should sum Product QP01 combined with Salespoint 1200 + Product QP01 combined with Salespoint 1400 (In this case result = 5)