Key that resets based on a column value

jerome

New member
Hi
Do you know if it is possible to have a simple key generated in Anatella, but that would reset each time a value in a column change.
Let’s imagine a one column table that would contains the following values.

Column1Name

ValueABC

ValueABC

ValueABC

ValueXYZ

ValueXYZ

Value123

Value123

Value123

Value123

Value123

I would like a key to be re-generated each time the value is different from one row to another.

The results that I would like to have is the following:

Column1Name ColumnKey

ValueABC 1

ValueABC 2

ValueABC 3

ValueXYZ 1

ValueXYZ 2

Value123 1

Value123 2

Value123 3

Value123 4

Value123 5



I hope that the here above sounds clear.

Many thanks in advance.

Regards.
 

Support

Administrator
Staff member
Hi Jerome, See the solution in the attachment
 

Attachments

  • key_counter.anatella
    1.3 KB · Views: 213
Top