Record ID find min in column then count.

[MinhTa]

Hello,

I would like to find the min in record id column then start counting/numbering from there on. Do you know any way to perform this action?

Thank you.

Ex:

Min in this column is 5 and the table will start counting from 5 to 11.

[Luke_C]

Hi @MinhTa 

I don't know that I fully understand the goal. To get the min, you can use a summarize tool. To get the values in order  you could sort the record ID. Can you provide some more context around what you mean by counting from 5 to 11? Sorting should get the data in order and bring the min to the top. 

[MinhTa]

@Luke_C so want to find the min in the table then run the same operation as tool Record ID. The table i am working on is a small part of a bigger table (separated using filter tool). I did some modifications and changes to the order of the small table and I want to keep the current order after I union the small table with the big one. I took the small table out around middle of the big table so after union, I want it back to the middle. Right now, the union tool made this table display at the bottom and I dont like that. Do you know any ways to solve this issue?

[Luke_C]

@MinhTa Could you sort based on RecordID and then add a new recordID tool? I think if you can provide some more sample data, both how it appears and what you ultimately want it to look like that will give a better idea of what you're looking for.