Create incremental field

[#1]

Hi,

I am looking to set up a field that is incremented automatically by one for each field in my Billing, to create each KPI KPI_ID on my field.

Do you have any idea?

[anbu1984]

Can you explain your requirement with sample data and expected output

[#3]

Metric	Metric Id
User Experience	1
Business Transaction	2
Basepage	3
iFrame	4

I've got the field Metric, and i want to create Metric Id.

is it ok for you ?

[rustyfishbones]

You can use

RowNo() as MetricID

or try creating an inline Table and Assign your metrics with an ID

Regards

Alan

[anbu1984]

Use RowNo()

Load *,RowNo() As MetricId Inline [

Metric

User Experience

Business Transaction

Basepage

iFrame ];

[#6]

i did it first with an Inline, but the number of KPI will change in the time.

[#7]

i tried your solution, but the distinct doesn't work. i've got more then 1000 records.

[anbu1984 · Accepted solution]

Try AutoNumber(Metric)

[#9]

well done

i forgot this function.