Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Linking a unique table (that has some Null values)

Hi,

 

I need to link 2 tables. The first table has 'many' values and the second table has 'unique' values but also some NULL records which are causing the mapping to fail. Please can you tell me how to map the two tables? (where there is a NULL of course I expect to value to be returned when I use the "Related" formula which is fine)

 

Thanks,

 

CM

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I guess what I'm asking for is a left outer join for a table link, without having to merge the tables? is it impossible?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous,


      If your tables contains the records which can't match other table, it will shows the null value at the new table. You can try to use INTERSECT function to check if they contains the value which can't match.

      Records= INTERSECT(VALUES('Table'[Column]),VALUES('Table 2'[Column]))

       

      Regards,

      Xiaoxin sheng