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
    Icon for Community Champion rankCommunity 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
        Icon for Community Champion rankCommunity 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.