Working on challenge 481.
Built an iterative macro as part of my solution. The idea is that it will pull in the data, split part of it off, do a join for some processing, and send the rest back around to go through the macro again. That part, at least, appears to be working properly, and it is not the issue that I am seeing.
What I seem to be unable to figure out is why the join tool inside the macro is doing what it is doing.
In the first iteration the L input anchor gets 45525 records. The R input anchor (which includes the records going into the L input anchor) has 218953 records.
I turned on macro messages to try to debug the macro and found that with these inputs I get this line:
" 481 iterative macro (74) Iteration #1: Tool #12: 707119544 records were joined with 0 un-joined left records and 30244 un-joined right records"
I am at a loss for what that means.
Does it think that 707 million records are getting input?
