Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Append Queries create duplicate values

I have two table, one is coming from Teradata warehouse (Project ID, Project Name, Type, Cost Category, Cost, Funding, Status) and another table is coming from Excel (also with Project ID, Name, Type...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Turns out that I have some calculation in Query Editor before append queries happen, so I appeneded the queries before the calculationa, and the duplicate values are now removed. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I'm betting that you need to do a Trim or other cleanup of you column. My guess is that you have a trailing space or other type of difference in your actual values.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I tried both trim and clean in Query Editor, but the duplicate values still remain. Do you have any suggestions?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    That's quite weird. Can you share a little sample please? At lease some snapshots.

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Turns out that I have some calculation in Query Editor before append queries happen, so I appeneded the queries before the calculationa, and the duplicate values are now removed.