Hello, I have 2 data sources. mssql and postgresql. I have 2 tables that I can join with each other. join column productid. There is a (1-N) relationship. I select Mixed from the data source. When I do Join by field from Transform data, it gives (1-1) relationship.
did you try the inner or the outer join option?
Actually, I wanted to try it, but I want a simple left join. I looked at the examples and didn’t see what I wanted. Is there a join you would like to recommend? thanks
try the outer join?