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.
