2 Replies Latest reply on Mar 15, 2016 3:22 PM by Mary Brauch

    Full outer join is not bringing in all values

    Mary Brauch

      I have Table 1 and Table 2 that I am doing a Full Outer join on. I am joining on Person ID in both tables.

      Table 1 has 200 unique Person IDs. Table 2 has 100 unique Person IDs.

      I would expect a full outer join would still contain all Person IDs. In my case, I only get 100 when I start building in my worksheets.

       

      Is this because I am using that field to join? Can the field you join on have to have a match in both sources for it to populate?