Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 |
One solution is.
Cal:
LOAD Date(AddMonths('1/1/2019',IterNo()-1),'MMM-YY') As FYear,
IterNo() As FMonth
AutoGenerate 1
While IterNo()<=24
;
Output