Forum Discussion

emma313823's avatar
emma313823
Helper V
9 years ago
Solved

Relationships Issue

Hi All   I have an issue which I can't seem to figure out what is causing it.   I have pulled in two tables of customer related data of which a common relationship is the part number.  I pulled o...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Oops, change COUNTROWS to COUNT.

emma313823's avatar
emma313823
Helper V
9 years ago

there were 4.  I'm curious...not sure if you know or not, but if I use the query editor to remove duplicates prior to pulling the data in, why are duplicates still showing?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Are these text values or real numbers?

  • emma313823's avatar
    emma313823
    Helper V
    9 years ago

    I have both source files set to text

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Add a Text.Upper to your import prior to your removal of duplicates.

     

    You should also add that to your other table as well so that everything matches.

     

    https://msdn.microsoft.com/en-us/library/mt260665.aspx

     

    If you right-click the column in Query Editor you will get an option to Transform | UPPERCASE