Key that resets based on a column value

[jerome]

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]

Hi Jerome, See the solution in the attachment