Create duplicate row with different value

[titulshah]

I have a dataset with TERM and VALUE are two of the columns. I want to add 2 additional rows for each branch and product with 12 and 18 as additional TERM. I did a formula tool but that resulted in existing terms being overwritten as 18 and 12.

[grazitti_sapna]

Hi @titulshah , You can easily achieve this by using a text input instead of formula tool as below. Please let me know if it helped.

[binu_acs]

@titulshah One way of doing this

[Emmanuel_G]

@titulshah 

I tried to do that your ideas with formula tool and following union tool.

Let me know if this solution is ok for you.