Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Splitting rows in a table

jcicca
5 - Atom

Hi

 

I would appreciate any assistance with splitting (some) rows in a table, such that the values in the original row are split between the original and newly created row. 

It is best explained visually below and in the attached Excel file, which has further notes included. The rows which are to be split will have a known percentage to use for the split - as you can see, this percentage may be different for each row 

 

jcicca_0-1591846689046.png  jcicca_1-1591846708239.png

 

Thanks a lot!

JC

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @jcicca ,

 

I tried to comment as much as possible to help you understand my line of thought.

fmvizcaino_0-1591848620968.png

 

 

Let me know if you have any doubts about it, please.

Best,

Fernando Vizcaino

jcicca
5 - Atom

Thanks a lot Fernando for such a prompt and useable reply. 

It looks like it will work perfectly, and it's simple to follow, even for my newbie mind!

 

Labels
Top Solution Authors