3 Replies Latest reply: Nov 13, 2017 5:08 AM by Shraddha Gajare RSS

    Qlik Sense doesn't Create Synthetic Key

    Robert DAmbrosio

      Hello,

       

      i'm facing an issue in qlik sense.
      I have two .csv tables where there are three fields with the same name:

      Table1.csv

      name1 name2 name3otherother
      DataData
      Data
      Data
      Data

      Table2.csv

      name1 name2 name3otherother
      DataData
      Data
      Data
      Data

      Now when loading the data in the data manager I would expect the creation of a synthetic key linking the two tables in this way:
      name1 (Table1) -> name1 (Table2)
      name2 (Table1) -> name2 (Table2)

      name3 (Table1) -> name3 (Table2)


      Unfortunately that doesn't happen.

      Instead qlik sense automatically renames the field of the second table as:

      Table2.csv

      Table2.name1Table2. name2Table2.name3otherother
      DataData
      Data
      Data
      Data

       

      preventing the creation of the links.

      I tried to rename the field manually (like Table2name1 -> name1) but I receive an error that the names should be unique.


      Can someone explain me why this is happening?