2 Replies Latest reply: Dec 18, 2013 6:14 PM by Fabrizio Zorer RSS

    How to create a cumulate field loading a table?

    Fabrizio Zorer

      Hallo you all,

      could you help me? I'm facing with the following problem.

      I'm able to calculate the B accumulate value in column "B_cumul" using a chart object.

      I need to to do the same job, but using the script in the loading stage (create the field B_cumul)

      result using chart object:


      xls table source:

      A                           B

      a5
      b8
      c3
      d4

       

      scripting:

      Directory;

      T1:

      LOAD

           A,

           B

      FROM

      [..\..\..\elimina\testcum.xlsx]

      (ooxml, no labels, table is Foglio1);

       

      Thank you in advance for your time