Is This Content Helpful?
We're glad to know this article was helpful.
When joining tables with the option to keep all records, if all values in a field in one table match with all values in a field of another table, all records are included in the joined table. However, in some cases, when joining such tables, only some records are included in the joined table.
This may caused by leading spaces, preceding spaces, or both in the values of one or both of the join fields.
Remove the leading or preceding spaces from the values in the relevant fields before joining the fields.
Note: Change fieldname to the user's respective field name.
Note: Apply these steps on both join inputs to ensure that hanging or preceding spaces are not hindering a proper join, and proceed with the join operation.