I want to create the "order line" field like at 2. table
for each order id create row number that group by his order id.
How can i do that.
May be like this
LOAD [order id],
[order id] & '.' & AutoNumber(RowNo(), [order id]) as [order line]
But the loading a takes a very long time
The other option is this
[order id] & '.' & Rank as [order line];
If([order id] = Previous([order id]), RangeSum(Peek('Rank'), 1), 1) as Rank
Retrieving data ...