Creating new field to mark each record

[jagjivvt]

Hi, 

I need to mark each record based on CID, New_Site and Weekingdate. 

Script

LOAD

CID,

New_Site,
Weekending,

from ...

CID contains unique data, New_Site and Weekending are not. 

CID	New_Site	Weekending
CRS6CI00143608	DST	26/07/2020
CRS6CI00143914	Devonport	26/07/2020
CRS6CI00143998	Edinburgh	26/07/2020
CRS6CI00143564	Cavendish Nuclear (SAP)	26/07/2020
CRS6CI00143554	Edinburgh	26/07/2020
CRS6CI00143762	Devonport	26/07/2020
CRS6CI00143780	DST	26/07/2020
CRS6CI00144028	Rosyth	26/07/2020
CRS6CI00144030	Rosyth	26/07/2020
CRS6CI00144024	Edinburgh	26/07/2020
CRS6CI00143636	Edinburgh	26/07/2020
CRS6CI00143652	Skills & Learning	26/07/2020
CRS6CI00143991	Devonport	26/07/2020
CRS6CI00143665	Devonport	26/07/2020
CRS6CI00143642	Devonport	26/07/2020
CRS6CI00143778	Devonport	26/07/2020
CRS6CI00143719	D & S	26/07/2020
CRS6CI00143586	Cavendish Nuclear (SAP)	26/07/2020
CRS6CI00143886	Devonport	26/07/2020
CRS6CI00143670	Cavendish Nuclear (SAP)	26/07/2020

This is the data set in am loading and i need to mark each CID with the rolling number so example

CID	New_Site	Weekending	Rolling No
CRS6CI00143564	Cavendish Nuclear (SAP)	26/07/2020	1
CRS6CI00143586	Cavendish Nuclear (SAP)	26/07/2020	2
CRS6CI00143670	Cavendish Nuclear (SAP)	26/07/2020	3
CRS6CI00143719	D & S	26/07/2020	1
CRS6CI00143914	Devonport	26/07/2020	1
CRS6CI00143762	Devonport	26/07/2020	2
CRS6CI00143991	Devonport	26/07/2020	3
CRS6CI00143665	Devonport	26/07/2020	4
CRS6CI00143642	Devonport	26/07/2020	5
CRS6CI00143778	Devonport	26/07/2020	6
CRS6CI00143886	Devonport	26/07/2020	7
CRS6CI00143608	DST	26/07/2020	1
CRS6CI00143780	DST	26/07/2020	2
CRS6CI00143998	Edinburgh	26/07/2020	1
CRS6CI00143554	Edinburgh	26/07/2020	2
CRS6CI00144024	Edinburgh	26/07/2020	3
CRS6CI00143636	Edinburgh	26/07/2020	4
CRS6CI00144028	Rosyth	26/07/2020	1
CRS6CI00144030	Rosyth	26/07/2020	2
CRS6CI00143652	Skills & Learning	26/07/2020	1

Thanks

[tresesco · Accepted solution]

Try like:

Autonumber(CID, New_Site) as RollingNo

[jagjivvt · Accepted solution]

Thanks, 

It worked perfect. i changed it to 

Autonumber( CID,New_Site& Weekending) as RollingNo

and i now see the grouping

BBGrpControl	Weekending	New_Site	Count(CID)
			371
BBG1	26/07/2020	Cavendish Nuclear (SAP)	50
BBG2	26/07/2020	Cavendish Nuclear (SAP)	50
BBG3	26/07/2020	Cavendish Nuclear (SAP)	50
BBG4	26/07/2020	Cavendish Nuclear (SAP)	50
BBG5	26/07/2020	Cavendish Nuclear (SAP)	50
BBG6	26/07/2020	Cavendish Nuclear (SAP)	50
BBG7	26/07/2020	Cavendish Nuclear (SAP)	50
BBG8	26/07/2020	Cavendish Nuclear (SAP)	21

as it created and group for every 50 records. 

thank you for all your help. 

vijay