Create row based on cell value

[Hamder83]

Hi 

I'm brand new to alteryx, and i tried some of the solutions previous givin on the forum before creating this thread.

Lets say I have 1 line with a base price, and surcharge prices added on.

1.: Freight
2.: Oekozuschlag
3.: Maut
4.: Einlagerung
5.:Adressklärung

Potentially all 5 can be specified in the same line. But need to be split into difference linjes.

Were all the base text i the same, but the field Surcharge type needs a value if there is a value in one of the 4 fields.

Parcel Number Service,         Surcharge,                          Customer, Oekozuschlag
123456789        Freight                                                       Mystore         1
123456789        Surcharge      Non-convayable                  Mystore         

So if Oekozuschlag is bigger than null, then create a new row.
The service text has to be surcharge, and the surcharge field has to be non-convayable.


I hope it makes sense.

I really appriciate 

[JoeS · Accepted solution]

Hi @Hamder83 

I believe that makes sense, my translation skills have hurt me a little in updating the columns in your data as I wasn't sure on their name(s).

But what I have done, is filter for your condition (So if Oekozuschlag is bigger than null/0),

then added a formula to allow you to update the fields you need

then unioned this back with the original stream, thus duplicating the row

It's not a completed workflow, but should give you the foundation you need.

[Hamder83]

Hey JoeS 

Thank you very much, this is excactly what I needed!