Replace with Pseudo id

[#1]

Hi,

I am a very long string ID, which are the identifiers.

ID	Time	Field1	Field2	New ID
String a	09:00:00 AM			1
String a	09:30:00 AM			1
String a	10:00:00 AM			1
String b	09:00:00 AM			2
String b	09:00:00 AM			2
String c	09:00:00 AM			3
String a	10:15:00 AM			1

How can i replace the string IDs to a shorter version (as shaded)?

[kumarnatarajan · Accepted solution]

hi,

use below mentioned syntex in your load script

AutoNumber(ID) as [New ID]