Generate Sequence

[#1]

Hello!

Help me please ...

I have the following table and need to create a new column with a numeric sequence according to the amount of photos of each product.

I wish the results were as shown below:

[luciancotea · Accepted solution]

LOAD idProduct,

          urlPhoto,

           if( peek(idProduct) = idProduct, peek(Sequence)+1, 1) as Sequence

RESIDENT photos;

[#3]

Thank you!

[rwunderlich]

I think much easier is

autonumber(Recno(), idNumber) as Sequence

-Rob