Automate Accruals

Question

Hello, I'm trying to automate some accruals processes but I'm running into issues where the results are a lot fewer than what they should be. I've attached what I have so far in Alteryx and an example of what I'm looking for it to spit out, however it's not giving me these results.

Brown17 · Answer

The L and R on the Join outputs are blank - the J tab does have results.  Please see attached files as example inputs with the desired outputs in the last columns.  I'm not sure how to provide a copy of the work flow other than the screenshot included above?

Transaction Activity.xlsx

PM OTANB Accrued Revenue.xlsx

TonyA · Answer

My first thought is that some of the keys are not matching. Take a look at the "L" and "R" outputs and see if there are any data there. I don't see any attachments to your post. Can you include a copy of the workflow and some sample data?