Forum Discussion
Merge queries only returning partial information
Thank you for the suggestions and responses, unfortuently these did not resolve our issue, it appeared that when we were merging our data it wasn't importing all of the data even though it was demonstrating a perfect match and all possible causes for difference had been removed, to get around this my manager has completed a significant rebuild on our query as we had it broken up into different steps into smaller query tables. She has worked around the issue and we are back up and running.
Hi Stacey_Tucker ,
On your 27-row sample tables, can you add a query step to each that converts [GroupId] to number type BEFORE the merge step please? I understand this may not be appropriate for the entire dataset but, for the purposes of testing, this should ensure a perfect match between the respective [GroupId] columns.
If that still doen't work, please do the following to provide data that I can use to try and replicate the issue:
-1- Remove all columns except [Date Extract] and [GroupId] from Table1, and [Date Extract], [GroupId], and [Date SD Update] from Table2.
-2- Select Table1, do Ctrl+A to select the entire table, go to the Home tab > Enter Data. Paste the table in here. Hit OK then go to Home > Advanced Editor. Copy ALL of the M Code there and paste into a code window ( </> button above) here.
-3- Repeat step -2- for Table2.
Pete