That doesn't work, tried a table looping functoid as well. I'm kind of glad the looping functoids didn't work because that would have been a confusing solution since I've never needed to do that before in similar situations. I'm starting to think this is a mapper bug. I have no idea why it won't map the other records.
I've done countless 1 to 1 mappings and never needed to use a looping functoid. Also, I just created a quick test in another project and was able to do a 1 to 1 mapping with 2 very similar schemas and every record came over with no functoids.
Is this a mapper bug?