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

[Former Member]

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

[Alecsandra · Accepted solution]

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

[Former Member · Accepted solution]

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