Join snap not working

Ok, so you all helped me get past my issue with adding a GUID, and I appreciate it! But now I’m having a problem with my join snap not working. A pic is worth a thousand words so here it is:

The thing that is confusing is for the mapper just before the sort on the bottom side, shows the correct target schema:

image

But the mapper on the top side, does not show the correct target schema. My input schema is as follows on the top side:

image

But it’s showing the target schema as (same as bottom side):

image

And when I look at the output from the join it’s only showing columns with values from the top side, not the bottom side. I also added a trim function to the join columns (in the last mapper snaps) thinking maybe that was the problem, but it didn’t fix anything.

Here’s the setup for the join snap: