When calling the mergeJoin/ mergeLeftJoin function, you need to set the key type and payload type. Only one key stream and one payload stream is given for an input table. If multiple key columns or multiple payload columns are required, use the combineCol to combine columns.
You need to push the input tables into the related streams. You also need to configure the function to merge the ascend/descend tables by setting the isascend parameter to true/false.
Caution
The left table should not contain duplicated keys.
The left and right result tables are pushed out in separate stream. If required, use the combineCol to combine the left and right table into one stream.
Important
The mergeLeftJoin function has a isnull_strm output stream to mark if the result right table is null (the current left key does not exist in the right table).