Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];
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
];
Please check below