distinct no for field

[ramachandra_gee]

Hi Team,

could any one please suggest how to generate distinct no for site filed here.

site siteno

inida 1

us 2

kenada 3

site	state	disitnct	sales
India	ap	ongole	80
India	ap	nell	85
india	bhp	paradise	23
india	bhp	cellorium	45
us	remedy	calom	86
us	remedy	siral	75
kenada	kalosa	richel	66
kenada	kalosa	silaj	89
kenada	sumera	aparlak	25

Thanks,

Ram.

[tresesco · Accepted solution]

Front-end ? Try using chart like:

Straight table:

Dim: site

Exp: Rowno()

For script:

Load

       *,

       AutoNumber(site) as SiteNo

From <>;

[Anil_Babu_Samineni]

May be this

site & ' ' & RowNo() as site