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,
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

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
    11 years ago

    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
      11 years ago

      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.

      • amiquel's avatar
        amiquel
        Regular Visitor
        11 years ago

        Sorry, Im new in this tool. How can i import just a few columns? When i tried to import the tabel i get this error:

         

        Expression.Error: La clave no coincidió con ninguna fila de la tabla.
        Detalles:
        Key=Record
        Table=Table

         

        And i cant select just a few columns...

         

        thanls,