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