Adding Data to missing Month Automatically

[Karthick461]

Hi,

 I have 3 columns in my Input. Product, Period and Sum(sales). 

Like this..

Product Period   Sum(Sales)

M1         2021001              50

M1         2021002              60

M2         2021001              10

M2         2021002              12

M2         2021003              12

M3         2021002              50

M3         2021003              30

My Requirement is M1 is not there for 2021003 . so my output needs to add M1 2021003 and sum(sales) as 0

same way M3 doesn't have record for 2021001 , so it has to add to output

Output should be like this

Product Period   Sum(Sales)

M1         2021001              50

M1         2021002              60

M1         2021003              0

M2         2021001              10

M2         2021002              12

M2         2021003              12

M3         2021002              50

M3         2021003              30

M3         2021001              0

Any help on this

[atcodedog05 · Accepted solution]

Hi @Karthick461 

Let me know if this works for you

Hope this helps : )

[MarqueeCrew]

@Karthick461 ,

The help provided for you here is dynamic.  The workflow itself is a little less important than the thought process for creating it.  When you have missing data and want to create records to insert into your data, you must first figure out what complete data is and then subtract your given data.  That leaves you with the known-unknown data.  Here is how I approached the workflow:

I hope that this helps you to understand how I came up with a solution for your challenge.

Cheers,

Mark

[atcodedog05]

Happy to help : ) @Karthick461 

Cheers and have a nice day!