Insert Missing Rows

[DenisZ]

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. 

[Felipe_Ribeir0 · Accepted solution]

Hi @DenisZ 

One way of doing this

[ShankerV]

Hi @DenisZ 

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.