Count of month number

[kavita25]

Hello all ,

I hve  year column and I want  month count corresponding to year

For eg 

Year    month 

Jan 19   1

Feb 19.  2

Mar 19   3

.

.

.

Dec19.   12

Jan 20.  13 

Feb 20   14

.

.

Dec20.   24 

Any ans  for this highly appreciated.

Regards,

Kavita 

[paulselousyoriz]

Hi Kavita ,

I am not sure if this is what you want,but you can use the "RowNo()" to automatically create a row number.

Regards,

Paul

Test:
load * inline [
Year
Jan19
Feb19
Mar19
Apr19
May19
Jun19
Jul19
Aug19
Sep19
Oct19
Nov19
Dec19
Jan20
Feb20
Mar20
Apr20
May20
Jun20
Jul20
Aug20
Sep20
Oct20
Nov20
Dec20
];

Left Join (Test)
Load
Year,
RowNo() As Month
Resident Test;

Result:

Year	Month
Jan19	1
Feb19	2
Mar19	3
Apr19	4
May19	5
Jun19	6
Jul19	7
Aug19	8
Sep19	9
Oct19	10
Nov19	11
Dec19	12
Jan20	13
Feb20	14
Mar20	15
Apr20	16
May20	17
Jun20	18
Jul20	19
Aug20	20
Sep20	21
Oct20	22
Nov20	23
Dec20	24

[Saravanan_Desingh]

One solution is.

Cal:
LOAD Date(AddMonths('1/1/2019',IterNo()-1),'MMM-YY') As FYear,
	IterNo() As FMonth
AutoGenerate 1
While IterNo()<=24
; 

[Saravanan_Desingh]

Output