8 Replies Latest reply: Feb 15, 2017 8:27 AM by Rahul Pawar RSS

    RecNo aggregated by some fields

    Андрей Шепель

      Good day!

      Colleagues, what function in load script can calculate number of row, aggregated by some list of field?

      For example, i have table and in load script i need ti calculate file Position, aggregated by Agent and Day - All values of Points must have values from 1 to Quantity of Points in Agent-Day Range

       

       

      AgentDayPointPosition
      1MoA1
      1MoB2
      1MoC3
      1MoD4
      1TuA1
      1TuB2
      1TuC3
      1TuD4
      1WeA1
      1WeB2
      2MoA1
      2MoB2
      2MoC3
      2MoD4
      2TuA1
      2TuB2
      2TuC3
      2TuD4
      2WeA1
      2WeB2