Forum Discussion
Solved
Merge Queries Help
Hello there, I am trying to Merge two tables. Table 1 "US_Det_Cust_Ledg" (fig. 1) has been filtered a couple of times and Grouped By [Cust Ledger Entry No] (fig. 2) which is the foreign key linki...
Hi,
I think the reason i the different data type of the matching column. In the header, one is formatted as 1.2 and another one as 123. Standardize the data type and then merge the datasets.
Hope this helps.
Before the merge, the rows in the grouped query get filtered to only keep those where amount<> 0 .
Step #"Filter Amount <> 0"
So the rows that have null after the merge are the ones which had amount = 0 in the grouped query.