Alteryx Designer Desktop Discussions

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

How to add missing months in a data

8095220421
5 - Atom

Hi Friends,

 

Can you help me with a workflow which can add missing months with '0' values for all the Region, Plant and Product combinations? Below is the data sample that I am using.


Regards,

Sreekanth

2 REPLIES 2
messi007
15 - Aurora
15 - Aurora

@8095220421,

 

Please see below:

 

messi007_0-1613980504434.png

Attached the workflow,

Hope this helps,

 

Regards

Qiu
20 - Arcturus
20 - Arcturus

@8095220421 

It is a bit more difficult than it looks like😁

0222-8095220421.PNG

Labels