Alteryx Designer Desktop Discussions

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

Need help for Row Data split

Ram
5 - Atom
Cust IDProductScoreAdd On
2345CO4.31.25
2345PD1.81.25
2345SP0.25 
2345AU0.1 
2345VS0.1 
2345CO+PD2.5 

 

Wanted to know how CO+PD Score 2.5 can be split equally to the products CO, PD as the value should added in a separate column as Add on the end result should be like below

Cust IDProductScore
2345CO5.55
2345PD3.05
2345SP0.25
2345AU0.1
2345VS0.1
2 REPLIES 2
binuacs
20 - Arcturus

@Ram One way of doing this, it is more dynamic

binuacs_0-1677621573400.png

 

Ram
5 - Atom

Thanks binuacs. I appreciate your help and support in this. Greatly helped me.

Labels