title: Insert static rows in Target Table
body: <p><a href="https://i.stack.imgur.com/MGfqE.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MGfqE.jpg" alt="enter image description here"></a></p>
  
  <p>So I have a scenario based on the picture attached.</p>
  
  <p>In my source table, I only have TIER 1 available value and will be inserted in the target table.</p>
  
  <p>But the requirement requires that even if TIER 2 to 7 is not available, I should still insert it to the target table regardless if there is a value or not, and append a value of 0.</p>
  
  <p>I tried making another flow and putting the condition in router but it seems to be tedious as the Department is dynamic and can be multiple depending on the source.</p>
  
  <p>I would like to ask if there is another approach for this</p>