Join Table Activity - Join Type Left Not Working


I’m trying to join two tables, based on product name. I selected join type left as i want all the rows in the first data table to remain. However despite doing this, the output always removes the rows that do not have a match in the two tables, hence essentially the activity is doing a ‘inner’ join type. I tried changing between the 3 types but only get the inner type result.

Any idea why this is? Cant figure out why


possible to share you xaml file.


Hi, thanks for the response, i understood the activity wrongly. What i thought is that when joining left, it will preserve the order of the row in the left column as it is. But upon running a simple example i saw that for left column rows which don’t have data are inserted last. So i changed the work flow completely.

Thanks again