Forum Discussion
Merge Data not picking up appended data
I have a query (Query A) and I appended a query (Query B) to the end of it. In another query (Query C) I am doing a merge to Query A based on a unique identifier in Query A. However, when I do the me...
It looks like Query B (Project Code) isn't matching.
You can examine the data with the newish 'column distribution' , 'column profile' etc features and see what's up with the data( there might be spaces or hidden characters in the field used to merge) so it'll need to be cleaned up.
OR the merge is done with an inner join and there are no matches
It looks like Query B (Project Code) isn't matching.
You can examine the data with the newish 'column distribution' , 'column profile' etc features and see what's up with the data( there might be spaces or hidden characters in the field used to merge) so it'll need to be cleaned up.
OR the merge is done with an inner join and there are no matches