New Row with conditions in Alteryx

[DE22]

Hello, 

Could you, please help me to generate a new row/line by taking into consideration the conditions below:

1. All the Code field, should have a sufix:  "_1" if there is no other information into the columns "F-> K"

                                                                   "_2" if there are info's into the columns "F-> K"

2. Add a new line, which keeps all the columns, but with some modifications:  

One ACTIVE, from CODE column will be split by adding "_1" and "_2", as below: 

               * CODE columns with _1 will keep only values from A-> E, the rest will be blank

                * CODE column with _2, will takeover the info from F->G, and at the "E" column, will add the amount from "H &K"

3. If no information will be available in the "F->K", add only the suffix "_1" to the ACTIVE code. 

Please see the picture below for more clarity. Thank you!

[cjaneczko · Accepted solution]

Try this.

[DE22]

Thanks a lot! :p