AutoGenerate in Group

[maxsheva]

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.

[tresesco · Accepted solution]

Try:

Table1:

               LOAD AutoNumber(RowNo(),Example) as Num,

  * 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

];

[prma7799]

Please check below