Forum Discussion

amiquel's avatar
amiquel
Regular Visitor
11 years ago

An entry with the same key already exists error

Im importing diferente tables from a datamart, and i get this error when i try to import the fact table. Why is this?

 

Thanks,

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Typically that means that you have two columns with the same name and you need them to have distinct names within the query context.

     

     

    • amiquel's avatar
      amiquel
      Regular Visitor

      In this i dont have fields with the same name. I deleted all the other tables and i tried to import the fact table, and threw the same error. Any ideas?

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        Probably a lot of work, but I generally troubleshoot stuff like this by importing one column, do I get the issue? No, import half the columns, do I get the issue? Yes, import half as many columns again...and so on and so forth. Bisection troubleshooting method.