Forum Discussion

mhkarjiker's avatar
mhkarjiker
New Member
8 years ago

Relating a column (in one excel) which has a relating code, to the codes definition another table

Hi

 

I have two excel sheets I have imported into Power Desktop. The one excel has a revenue column with each row associated to a country code ($120; CA). In the other excel file I have the contry code (CA) in a column with its associated description (Canada). How do I link the two in Power? I basically want Power to see $120 is associated with country code CA and then associate CA to Canada

7 Replies

  • Christann's avatar
    Christann
    Icon for Advocate IV rankAdvocate IV
    8 years ago

    In the Relationships view,

    drag and drop one of the country code fields onto the other one to create a relationship.

     


    • mhkarjiker's avatar
      mhkarjiker
      New Member
      8 years ago

      Thanks

       

      When I tried doing that, it said:

       

      " You can't create a relationship between these two columns because one of the columns must have unique values."

       

      Help?

       

      • Christann's avatar
        Christann
        Icon for Advocate IV rankAdvocate IV
        8 years ago

        From what it sounds like you may have duplicate entries in you country table, say for instance two "Mexico's".

        Try editing your query to remove duplicates.

        First on your Home tab hit Edit Queries.

        Then select a column in the countries table.

        Next on the Query Editor Home tab under Remove Rows choose Remove Duplicates.

        Finally hit Close and Apply.

        Hope that helps!