Left Join on lookup

A lookup could generate new lines (like a left join), how is that possible? I thought that a lookup take only the first matching value.



You can specify the reference link name in the Multiple Rows Returned from link drop down while defining the Lookup Stage conditions.

So, the output will take as many matches from that reference link as exist there.