Generate Missing Data

[sven-abx]

Hello Community,

I have a column with the following values:
which represent the year and week for a stocklevel.
As you can see, some values are missing, because no data were reported.
Now I like to generate the “missing” data.
For example:
2015/01 4
2015/02 4
2015/03 4
2015/04 5

Values 2015/02 and /03 are generated and filled the the previouse value.

Is there an easy way to generate this date or do I have to build a loop?

BR,
Sven

[HansS]

Hi @sven-abx

I was think of something like this:

• Create a date range with an interval of one week (7d).
• Extract Year and Week.
• Concat them: join(string($Year$),"/", string($Week$))
• Do an outerjoin with your dataset.

gr. Hans

[sven-abx]

Hello @HansS,

worked pretty well!

Thanks!
BR,
Sven