Forum Discussion

MFurlongSTRAD's avatar
MFurlongSTRAD
Frequent Visitor
7 years ago
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...
  • Ashish_Mathur's avatar
    7 years ago

    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.