LEFT OUTER JOIN using Join Data Tables

[jpreziuso]

Hi I am trying to accomplish the following:

Using Join Data Table:

But when I try to do this join which should give me everything in Table 1 that does not appear in Table 2, I get the following error:

“RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0x000000FF”

Someone please help me with how to accomplish this. Do my tables need a key?

[ppr (Peter Preuss)]

A Left outer Join done with Join DataTable is like:

Join Type: Left
dtLeft.JoinCol = dtRight.JoinCol

in the returned dtJoin Result we get also back the inner join results. But when we filter the dtJoinResult on dtRigtht.JoinCol is empty then we removed the inner join rows and the left outer join rows will remain

[jpreziuso]

This makes sense. Thank you