Insert 'zero-values' for dates without data

[ArminL]

Hey Community,

I have the following table with consumer data for a certain time period (e.g. 2017-12-21 to 2017-12-23) but when a consumer did not consume on a certain date, there is obviously no data for her.

Nervertheless I would like to have all dates for all customers in the table, with days where there was no consumption "value = 0".  Anybody can give me a quick hint? :)

Consumer	Date	Value
1	2017-12-21	3
2	2017-12-20	5
2	2017-12-21	2
2	2017-12-22	12
3	2017-12-22	6
3	2017-12-23	8

Thanks in advance and cheers

Armin

[jasperlch · Accepted solution]

Hi @ArminL,

The workflow below should do:

[ArminL]

Thanks @jasperlch for the quick help. Appreciate it :)