We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Allocating Cost using Alteryx

JenMBRamos
5 - Atom

Hi, 

 

Can someone help me on what is the best tool that I can use to allocate costs/data. I have a separate file for the amount to be allocated and another file for the basis of allocation.

 

I attached a sample data with expected output.

 

Thank you! 🙂

2 REPLIES 2
Christina_H
14 - Magnetar

This should do it:

Christina_Hurrell_0-1632829587263.png

 

JenMBRamos
5 - Atom

Thanks for helping me on this! 🙂

Labels
Top Solution Authors