Question on Duplicates

Question

I have imported a table and can't create a relationship because it says there aren't unique values in one of the columns.&nbsp;The problem is they are unique if you look at capitallization.&nbsp;Example - Insurance Company table is the one that would list every insurance company with a unique code. (We are limited in our database to 3 characters and some have to start with certain letters)&nbsp;Data may be:&nbsp;Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CodeBlue Cross&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BCBlue Cross of SD&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BcFirst American&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FBxTricare&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Tx&nbsp;In another table (Accounts) we have&nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; InsCodeKathy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BCJim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BCSue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bcetc...&nbsp;When I try and create a relationship between InsCode and Code it says neither have unique values. Is there a way to have it look at capitalization?

parry2k · Answer

Power Query M is case sensitive but DAX is not.

So you need to add an index column in your master table in power query and use merge queries in your transaction table mathcing on code and get index number from master table, once this is done then you can set relationship between you master and transaction table on index column.

Let me know if you need help to get this up and running.

pxg08680 · Answer

kattleesWhere are you getting(importing) the data from. Try to get distinct Codes for both instead of all the codes.

kattlees · Answer

Here is a picture. On the right is in the query itself. You can see the capitalization is unique. Thus giving unique values.

On the left is when I pull the values into a table. The capitalization changes.

Forum Discussion

Question on Duplicates

3 Replies

Related content

Duplicate Slicer Question

Duplicate ranking

Bookmark questions

QUESTION::PIPELINE::COPY DATA::DUPLICATE DATA COPY

Architecture question and brainstorming