3 Replies Latest reply: Oct 17, 2010 9:57 AM by Jonathan Dienst RSS

    Table connector

      I am a new user of Qlik and i am trying to create my first dashboard from tables located in Peachtree Accounting 2011 software using ODBC connection. I am able to load tables but there is no connector linking the tables so i am not able to see a relationship in the list box. Can someone tell me if it is possible to link tables manually or is it that i am doing something wrong.

      Looking foward to a solution

      Eddison

        • Table connector
          renjith pl

          hi,

          I think you have to concatenate the table, read the concatenate function from the tutorial, that may give you an idea.

          regards

          ren

          • Table connector
            Chris Cools

            Hello,

            i also use tables via ODBC, and i rename the fieldnames in the loading script from tables that i want to be linked.

            for example:

            SQL SELECT loc1 as LOCATIE,
            FROM qryLocMet1ArtAlsPicklocatie2;
            SQL SELECT Loc2 as LOCATIE,
            FROM qryLocMet1ArtAlsPicklocatieMaar2Art;

            Loc1 and Loc2 are the same information but in a different table, by renaming them as 'LOCATIE', they are

            linked!

             

            grtz,

            chris

            • Table connector
              Jonathan Dienst

              Eddison

              Qlikview links tables when they contain a field with the same name, as in Chris' example above.

              Jonathan