Date ,Year and Month sequence number generation

[Anonymous]

Hi Experts,

i have  Data like this

load * inline [

Year	Month	Quarter
fy15	1/1/2015	fy15q1
fy15	1/2/2015	fy15q1
fy16	1/3/2016	fy16q1
fy16	1/7/2016	fy16q3
fy17	1/1/2017	fy17q1 ];

i want generate a sequence number all the year and month and quarter

here year is having duplicate record i want sequence number like

fy15  is 1

fy16 is 2

autonumber is not giving correct values

pls suggest

[eduardo_dimperio]

Hi,

I dont understand how you want your numeration, that'll be by year?

What kind output you need, Type 1 or 2?

Output Type 1

Year	Month	Quarter	Number
fy15	1/1/2015	fy15q1	1
fy15	1/2/2015	fy15q1	2
fy16	1/3/2016	fy16q1	3
fy16	1/7/2016	fy16q3	4
fy17	1/1/2017	fy17q1	5

Output Type 2

Year	Month	Quarter	Number
fy15	1/1/2015	fy15q1	1
fy15	1/2/2015	fy15q1	1
fy16	1/3/2016	fy16q1	2
fy16	1/7/2016	fy16q3	2
fy17	1/1/2017	fy17q1	3

[el_aprendiz111]

Hi,

tmp:
LOAD *, AutoNumber(Quarter & 'Quarter') as nw;
load * inline
[
Year,Month,Quarter
fy15,1/1/2015,fy15q1
fy15,1/2/2015,fy15q1
fy16,1/3/2016,fy16q1
fy16,1/7/2016,fy16q3
fy17,1/1/2017,fy17q1
];

[Anonymous]

i have 3 period tables when I apply same , it is giving alternate number but I want see only sequence number

[Anonymous]

I want generate unique number for month ,quarter and year separately and unique number

when I have 3 tables autogenerate  wont work properly this way

[Anil_Babu_Samineni]

Expected result from given data?