Replacing Values Based on Multiple Criteria

[robertbrussell1]

Hello All - I have been troubleshooting an issue for a couple of days and figured I'd give the community a shout out. 

My objective is to replace the Expected Category Item Values with the Observed Category Volume Value for each corresponding month. Below is a before and after example of how the output would look. Does anyone have a suggestion on how this can be done within the Alteryx environment!? Thanks.

[jdunkerley79 · Accepted solution]

I suggest the following.

Use a filter to get the observed volume values

Then join this back to the original set

To ensure no loss of records use a union to merge Left and Join output

Finally, a formula to correct value

Quick sample attached