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

Allocating an amount utilizing percentages in another input file.

jdkatz1
8 - Asteroid

Hello, 

 

I am new to Alteryx. I am trying to figure out how to allocate a number based on %'s contained in another input file. I want Alteryx to allocate the amount to various entities and give the results on a new tab within excel output.

 

Example

 

Investment - DEST

Amount - $100

Allocations - 50% to Fund A, 50% to Fund B. 

 

Result   

Fund A   

$50

 

Fund B

$50           

8 REPLIES 8
CarliE
Alteryx Alumni (Retired)

@jdkatz1 

 

You will need to use a summarize and join for this. Do you have a dummy data set you can provide?

 

Thanks!

Carli
PhilipMannering
16 - Nebula
16 - Nebula

Hi @jdkatz1 

 

How you do this depends on what format your data comes in.

Take a look at one possible solution (attached),

PhilipMannering_1-1655308647720.png

 

jdkatz1
8 - Asteroid

.

jdkatz1
8 - Asteroid

attached are the sample inputs

PhilipMannering
16 - Nebula
16 - Nebula

@jdkatz1 

 

I see. Maybe something like this,

PhilipMannering_0-1655310861333.png

 

jdkatz1
8 - Asteroid

This worked! Is there any way to have 1 output with the original data on the first tab and another tab with the allocated amounts?

PhilipMannering
16 - Nebula
16 - Nebula

Yep. Something like this?

jdkatz1
8 - Asteroid

I'm looking for the first tab of the output to be the original data input (the values excel). The second tab of the output would be the allocated amounts by fund. 

Labels