Add sequential number to field

christianr58641
Tera Contributor

Hello and happy Wednesday!

 

I have some new data that was imported into SNOW from another source that has an "ID" field with a unique sequential number assigned to each record. For instance, a record with a "Name" of "George" has an "ID" of 5, and was the 5th record generated on the old source. The "Name" and "ID" field are just simple String type.

 

I've been asked to find a way to add the next sequential number to the ID field when creating a new record for this app. So, if the last record has an ID of 499, if I create a new record it will automatically be assigned an ID 0f 500. 

 

Any tips on how to realize this?

0 REPLIES 0