Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Create row based on cell value

Hamder83
11 - Bolide

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 

2 REPLIES 2
JoeS
Alteryx
Alteryx

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

 

Workflow.png

 

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

Hamder83
11 - Bolide

Hey JoeS 

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


Labels