Fund Allocations

[jdkatz1]

Hello, 

I am trying to allocate fair values to multiple funds based on their respective allocation percentage. I have 2 separate input file (values and allocations). I am stuck at the find a replace stage where i am trying to Vlookup the company and value and multiply it by the allocation percentages. I have two output points that go to the same excel, sheet 1 will be the original data ("values" excel), and sheet 2 will be the allocated amounts by fund. 

Attached is the Alteryx and sample files

[DataNath · Accepted solution]

I'm a little confused on what you're stuck on exactly. If it's just the Multi-Field + Outputs then the attached workflow should work. If you're not storing the workflow and input files in the same place then you'll need to edit the paths in the Input and Output Data tools to match the locations you use.

[aegon · Accepted solution]

Hi @jdkatz1 ,

I modified your workflow a bit by replacing the append tool with join which I find more appropriate to the lookup process that you want to do. 

The multifield config shoud be below where CurrentField = Fund A, Fund B, Fund C multiplied by CQ Value

This is the first multifield ouput where I retained the original "Fund" fields. 

This is the second multifield tool where "Fund" values are overwritten with the calculated results.

You can see the multifield configurations in the attached workflow.

Hope this is the output that you are expecting.