Hello,
I have two queries I'm trying to merge. Both have a Unique Identifier column (Column A, "Client #") and about half of the values on Table 2 are on Table 1. I'm trying a Left Outer join. When I try to merge them, I get the following error:
DataFormat.Error: We couldn't convert to Number.
Details: (Archival5162016)
In both queries, I've formatted the 'Client #' column as a Number, so I'm not sure why this occurring.
Thanks!
I have two queries I'm trying to merge. Both have a Unique Identifier column (Column A, "Client #") and about half of the values on Table 2 are on Table 1. I'm trying a Left Outer join. When I try to merge them, I get the following error:
DataFormat.Error: We couldn't convert to Number.
Details: (Archival5162016)
In both queries, I've formatted the 'Client #' column as a Number, so I'm not sure why this occurring.
Thanks!