We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Calculation of a value into multiple row

JaesunK
5 - Atom

Hi,

 

I would like to allocate a value in different rows into multiple rows. For example, the below tables show what I would like to achieve. 

 

Source table

ItemAmount

a

1

b

1

c

1

a+b

2 (to be allocated into a ,b)
a+b+c3 (to be allocated into a, b, c)

 

 

Resultant table 

ItemAmount
a3 (1+1+1)
b3 (1+1+1)
c2 (1+1)

 

Could anyone please advise which tool(s) & formulas that I can use to make this happen? 

 

Kind regards,

Jaesun

6 REPLIES 6
Felipe_Ribeir0
15 - Aurora

Hi @JaesunK 

 

One way of doing this (updated)*:

 

Input:

Felipe_Ribeir0_1-1667040943212.png

 

Output:

Felipe_Ribeir0_0-1667044598746.png

 

 

 

 

JaesunK
5 - Atom

Hi @Felipe_Ribeir0 

 

Thanks for your reply and the proposed solution.

 

I noticed that this proposed solution might only work for the sample I provided.

 

I have attached another sample with the actual numbers as attached (it has input, working, and outcome tab separately)

 

Could you please help me with this sample? 

 

Kind regards,

Jaesun

Felipe_Ribeir0
15 - Aurora

Hi @JaesunK 

 

Although your input (Book1.xlsx) seems similar to the first sample, the solution is very different (for example, the first sample had + separating items, this new input uses /). Anyway, here is the solution adapted to the second input.

 

Felipe_Ribeir0_0-1667183344497.png

 

JaesunK
5 - Atom

This is fantastic!

 

Thanks for your help @Felipe_Ribeir0

 

Kind regards,

Jaesun

JaesunK
5 - Atom

Hi @Felipe_Ribeir0

 

Just one quick additional question please.

 

Now I would like to allocate "Distribution Alpha/Beta/Gamma" into a certain ratio like 50% Alpha, 40% beta and 10% Gamma, would you be able to advise how I can reflect this change please?

 

Kind regards,

Jaesun

 

Felipe_Ribeir0
15 - Aurora

@JaesunK you can use formulas like these ones to do this:

 

Felipe_Ribeir0_0-1667198584954.png

 

Labels