How to generate missing months for a field?

[Rajat1]

Load * Inline [

MonthYear, user_id

Jan2023,1

Jan2023,3

March2023,1

March2023,3

];

Now i want to autopopulate the missing month that is feb2023 and to create a new field called Occ,

My output should look like, 

MonthYear, user_id,Occ

Jan2023,1,1

Feb2023,1,0

March2023,1,1

Jan2023,3,1

Feb2023,3,0

March2023,3,1

Thanks,

Rajat

[Or]

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/797824/1/Gener...

The document this was attached to was seemingly removed, but this PDF details all of the necessary techniques for filling in missing data. In your case it's the one covered on pages 7 and 8. This is also covered in a separate document:

https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637