Right anti join in Dataflow-CodePudding

Is it possible to perform right anti join in Dataflow?

I can see joins in Dataflow but I didn't find right anti join .

Any help is appreciated

CodePudding user response：

AFAIK, Currently Anti joins are not supported in Data flows. Only the following joins are supported.

enter image description here

If your Source tables are from SQL, its good if you perform a stored procedure at source for Right anti join in Dataflow.

If not, you can try the below workaround using Exists transformation.

Exists transformation takes left and Right streams and gives the records of left records which are not in Right stream.(Left Anti join)

To achieve Right anti join, you can change the incoming streams.

Sample demo:

Left source data:

enter image description here

Right source data:

enter image description here

Exists transformation:

enter image description here

Result:

enter image description here