1 Reply Latest reply: Nov 26, 2013 11:26 AM by Anton Wibowo RSS

    How to build ERD with keys table?

      HI,

      How to build ERD with keys table?

      Can i have links or explanations?

      I got lost !!!

        • Re: How to build ERD with keys table?
          Anton Wibowo

          Hi Alon,

           

          I assume you want to create the datamodel? Do you have a screen shot of your current ERD (table)? That would help.

           

          The way it works in Qlikview is, you may need to rename the key field that you want to join with another table. Once the key fields are the same, it will automatically create the join (It's not the same as in SQL, which you just drag a line from one table to another - you need to do it via Qlikview Script).

           

          For example:

          Table Employee has 2 fields:

          EmpID, EmpName

           

          Table Department has 3 fields: (Just for our test purpose, ignore how "Emp Number" is created in Department table )

          Emp Number, DepartmentID, DepartmentName

           

          To join the Employee and Department via EmpID or Emp Number as the key, you need to rename either one to match one another. So either you need to rename Emp Number to become EmpID (or vice Versa).

           

               EmpID as [Emp Number]

          or

               [Emp Number] as EmpID

           

          Hope this helps,

           

          Best regards,

          Anton