Is there any plugin similar to merge join to join any two different stream at different condition
Yes — in AutomationEdge Process Studio there are steps you can use to join two (or more) streams under different conditions — not only Merge Join:
Available join-type steps in AutomationEdge
These are part of the Joins plugin:
Merge Join
-
Joins two streams based on a common key field (Inner, Left Outer, Right Outer, Full Outer).
-
Requires sorted keys.
Multiway Merge Join
-
Allows joining more than two streams at once on a join condition.
-
Useful when you need to combine multiple inputs in a single join step with INNER or FULL OUTER logic.
Merge Rows (diff)
- If your condition is about comparing and merging rows (determining changed/new/identical rows) rather than a straight relational join, this step can merge two streams and emit flags.
Join Rows (Cartesian product)
- If you want to join streams without a key or under condition logic you define manually, you can use a Cartesian product join combined with conditions in a filter step afterward.