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:
But the mapper on the top side, does not show the correct target schema. My input schema is as follows on the top side:
But it’s showing the target schema as (same as bottom side):
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: