Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Automate Accruals

Brown17
5 - Atom
‎03-23-2022 12:19 PM

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_0-1648062842337.png

Brown17_2-1648063080879.png

 

Labels:
Reply
0 Likes
2 REPLIES 2
TonyA
Alteryx Alumni (Retired)
‎03-23-2022 12:50 PM

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?

Reply
0 Likes
Brown17
5 - Atom
‎03-23-2022 01:18 PM

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?

Preview file
10 KB
Preview file
11 KB
Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels