I am using the join tool to merge two datasets into one. I see the data on the left when viewing the data, but when I view the data in the join view some data from the left is missing. Why is this and how do I fix it?
Can you provide a screenshot of what you mean? Which output anchor are you looking at (L,J,R)? The L only shows where there were no matches on the right, the J shows where there are matches on both, and the R show where there are no matches on the L.
Can you share the configuration window of the join? The workflow doesn't show where the issue is. Are the data types the same? Are there trailing white spaces on one side preventing the join?