Skip to Content
avatar image
Former Member

Joining a Table with another table thats empty in HCI-DS

Hi SAP Experts, Im trying to do a Left Outer Join between two tables, left been my transform and right the table TVM3T, but most of the records of my Transform dosent have a counter part in the other table, I checked the log for more details and as it turns out the table comes out blank because there is no match.

TVM3T12[1] STOP 0

Transform7-Join25: 0 STOP 5507

Transform7-Join25: 1 STOP 0

Is there something Im missing.

Best Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 06, 2017 at 03:41 PM

    Hi Luis,

    Left join returns all entries from left table and the matching entries from the right table. So if there is no match with right table you should still the entries from Transform.

    Best

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded