Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
5 years ago
Solved

Problem with unique values

I have a table of shipments statistics 'Query 1', and a table with distances from our warehouse based on postnumbers 'Rev 202011'. I'm trying to create a relationship between the postnumbers ('query...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Dhjlm ,

     

    In addition to what Greg_Deckler mentioned in his response, do check if there are NULL values in the columns that you are trying to create relationship on. ('query1[POSTNR3] and 'Rev 202011'[Postnr] in your case)

    I have experienced similar error in the past due to the NULL values in the key columns that are used for creating the relationships between two tables.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Dhjlm ,

 

In addition to what Greg_Deckler mentioned in his response, do check if there are NULL values in the columns that you are trying to create relationship on. ('query1[POSTNR3] and 'Rev 202011'[Postnr] in your case)

I have experienced similar error in the past due to the NULL values in the key columns that are used for creating the relationships between two tables.

 

Thanks,

Pragati