Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate rows for missing months with 0 value for sales

Oz
6 - Meteoroid

Can somebody help me on this? I have been reading the forum and trying to do it myself but have always failed to find the right result.

 

I want to create rows which would add missing months in my file, but those new months should have 0 value for both pack and cash sales. The starting point for new months would be the minimum date in Date field and the ending point would be maximum date in Date field.

 

As you can see in the attached file I am missing May until June 2013 data for Xantium product and March until June 2013 data for Zurat. Can we add those months with 0 value for Packs and Cash value?

 

Thanks a lot for helping on this one.

Gorazd

2 REPLIES 2
s_pichaipillai
12 - Quasar

Hi @Oz

 

try the attached one . it should work for you

i did not add any comments , but let me know if you have any questions on this workflow 

Oz
6 - Meteoroid

Thank you very much, you solved my problem :)

Labels