2 Replies Latest reply: Apr 19, 2017 1:49 AM by P M RSS

    AutoGenerate in Group

    Max Shevchenko

      Hi,

       

      What is the way to generate NUMBERS for text for each group?

       

      Table1:

      LOAD * INLINE [

      Example, Date, Value1

      Group1, Example1, 70

      Group1, Example2, 50

      Group1, Example3, 20

      Group2, Example1, 10

      Group2, Example2, 100

      Group3, Example1, 70

      Group3, Example2, 70

      Group3, Example3, 70

      ];

       

      A result I need

       

      Num, Example, Date, Value1

      1, Group1, Example1, 70

      2, Group1, Example2, 50

      3, Group1, Example3, 20

      1, Group2, Example1, 10

      2, Group2, Example2, 100

      1, Group3, Example1, 70

      2, Group3, Example2, 70

      3, Group3, Example3, 70

      ];

       

      Thx.