Insert Missing Rows

I have a workflow where I want to see revenues, Cogs and salary for each company. However, in some companies there is no COGS or salary for example. I want the flow to add the rows that are missing and fill them will Null or 0's for all months. What would be the best approach for this?

Workflow/input is attached.

InsertMissing.yxmd

Preparation

Accepted answers

One way of doing this

InsertMissing.yxmd

All comments

One way of doing this

InsertMissing.yxmd

Step 1: Use unique tool to get the unique values of Item and Company ID separately

Step 2: Use the append and Join the input once again

Step 3: Use use Union tool (Left join - That will include both L and J node)

Solution is for your reference.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703