Skip to Content
0

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

Jan 05, 2017 at 09:32 PM

108

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Alecsandra Dimofte
Jan 06, 2017 at 03:41 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Alecsandra, I managed to work my way with filters, there was a miss use of those, Thanks

0