16 Replies Latest reply: Apr 9, 2018 12:29 PM by Bill Markham RSS

    Avoiding Synthetic Keys in Multiple Data Connections

    Elizabeth Viso

      Hello!

       

      I have 5 excel sheets I am using for an app and each sheet has the following columns:

       

      Year

      Month

      Quarter

      PScore

      HScore

       

      Obviously, they cause a synthetic key because they are duplicated for the most part. I can't change the format of the excel sheet but is there something I can do in Qlik to avoid this? Would renaming them be the key to avoiding it?

       

       

      Thank you1

       

      Updated file