0

Left/Right Outer joins

joins

Hello,

I somehow struggle to get my Left/Right outer join working (see print screen). Could you please confirm the Left/Right refers to the fields below (in that instance, "Audit sans..." is considered as Left).

I use as a Join column a String that is found in both my input tables, but the result is somehow always empty (although I checked and there are some common elements). Any suggestions ? 

 

Clément

2 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 5 yrs ago
    • Reported - view

    A quick search on the web shows many responses to this question. Check this out.

    • Shai_Ben_Ami
    • 5 yrs ago
    • Reported - view

    Hello,

    The preview table in the data modeling tool is working on the top 50 rows from the data source. There is a high probability that 50 rows from table A, and 50 rows from table B wont match to each other and then you will get an empty preview.

    You have the ability to change the preview size by using the "Preview Size" ribbon button

    If you try to execute the full ETL, the table is still empty?

     

    Thanks,

    Shai.

Login to reply

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 2Replies
  • 37Views
  • 3 Following