Hi,
I want to add suffix to my all duplicate numbers. This suffix number should restart from each duplicate. Example below.
Example Values are::
ABC
ABC
ADF
ADF
GHR
GHR
GHR
want to generate it as
ABC_1
ABC_2
ABC_3
ADF_1
ADF-2
GHR_1
GHR_2
GHR_3
These duplicate values are different, can be less than 10 or can be more. Overall data has more than 3000 values.
How can append it in Query. Challenge is to restart suffix numbers on next value, Other wise I can merge it with ID autonumber, but it then wont restart from each next value.
Thanks
I want to add suffix to my all duplicate numbers. This suffix number should restart from each duplicate. Example below.
Example Values are::
ABC
ABC
ADF
ADF
GHR
GHR
GHR
want to generate it as
ABC_1
ABC_2
ABC_3
ADF_1
ADF-2
GHR_1
GHR_2
GHR_3
These duplicate values are different, can be less than 10 or can be more. Overall data has more than 3000 values.
How can append it in Query. Challenge is to restart suffix numbers on next value, Other wise I can merge it with ID autonumber, but it then wont restart from each next value.
Thanks