Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge with Left Outer Join shows 0 matched

I was trying to perform merge in Query Editor between a tabled pulled from a Teradata warehous and an Excel file (only one row from each query with ID = 10), but it shows 0 matched even though the data type for these two colums are the same. Do you know what might cause the issue? I also took a look at permission setting for each souce and try to configure it to different levels, but it still shows 0 matched 

Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    First make sure the data type of the referenced columns are the same. Remove the non-printable characters in these two columns and try to merge again.

     

    Regards,

    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    First make sure the data type of the referenced columns are the same. Remove the non-printable characters in these two columns and try to merge again.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-yulgu-msft,

      Thank you. What I discovered was there was an extra space in the Excel sheet, so the joins show no match.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Make Sure they are ( totally ) the same by making the desired columns ( Lower or Upper case or Capitalize each word ) in both tables