Forum Discussion
Visualizing Data with Null Records AKA Left Join
I notice when you have a table and you bring in a field, say "customer". It results in a list of rows. Lets say 25 rows for this example. Next you want to bring in another field. For this example let...
Hello,
I would recommend you look at the model. Is the relationship between the two tables a many to many? This would indicate there are "duplicates" in both files. Note, blanks are consider duplicates. This may cause the issue you are seeing. I had to create a new variable such that the "right" table that I wanted to join (left join) to the base table had unique values in the "key/variable" that was used to merge. Then I reconnected the data so that it is a "one to many" connection. I believe a "one-to-one" connection would also work. Now the visual sums properly.