Hi,

I am trying to accomplish a left outer join in my dataflow and not getting the expected result. I have created two sample datasets like this:

Dataset Q: {A, B, C, D}

Dataset P: {(A,r), (A,s), (B,r), (B,s), (C,r), (C,s), (D,r), (D,s)}

Doing a left outer join on this in SQL returns the following:

Dataset QP: {(A,r), (A,s), (B,r), (B,s), (C,r), (C,s), (D,r), (D,s)}

Trying to do the same in my dataflow using an augment transformation (Dataset Q on the left, Dataset P on the right) with the lookup multiple values option returns this:

Dataset QP: {(A,(r,s)), (B,(r,s)), (C,(r,s)), (D,(r,s))}

Instead of returning multiple rows for multiple matches, it instead creates a multi-value field. Is it possible to get the results of a true left outer join in a dataflow or within an Einstein query so instead of creating a multi-value field, I instead get multiple rows returned per match?