4 Replies Latest reply: Sep 24, 2014 6:21 AM by sujeet singh RSS

    If condition in load

      Hi freiends,

       

      I have a table like

       

      A B C D                    E

      1  2 3 sales              Profit

      2 3 4  Commisions     Loss

      6 8 9  Margin            Profit

       

      Now I have to load based on coumns D and E using resedent load.

       

      If D= sales and e= Profit then A-B as xxxx

      else if D=Commission and E = Loss as YYY etc

       

      Thanks

      Pavan