Create yearmonth record for each id

[Anonymous]

Hi all

I have a table below:

Id	Year-Month
1	201601
2	201604
3	201611
4	201703

I would like to generate the table below:

Header 1	Header 2
1	201601
1	201602
1	201603
1	201604
1	201605
1	201606
1	201607
1	201608
1	201609
1	201610
1	201611
1	201612
1	201701
1	201702
1	201703
1	201704
1	201705

Other Record also generate until today year month.

Best Regards,

Louis

[Anonymous]

Anyone can help?

[marcohadiyanto]

Hi Louis,

Try searching for master calendar.Optimized code for Master Calendar

Regards,

Marco

[antoniotiman]

Hi Louis,

LOAD ID,
Date(AddMonths(Date#(YearMonth,'YYYYMM'),IterNo()-1),'YYYYMM') as YearMonth Inline [
ID,YearMonth
1,201601
2,201604
3,201611
4,201703
] While Date(AddMonths(Date#(YearMonth,'YYYYMM'),IterNo()-1),'YYYYMM') <= Date(Today(),'YYYYMM');

Regards,

Antonio