3 Replies Latest reply: Aug 16, 2012 2:16 AM by At titude RSS

    Join between two tables on common key

      Hi,

       

      I have two tables in below format

       

      TableA:

      Load * Inline

      [

      SR No,Name, City

      1,A,C

      2,B,D

      ]

       

      TableB:

       

      Load * Inline

      [ No,Full Name, Occupation,salary per month

         1,A,EE,10000

          2,B,DDDDD,20000

      ]

       

       

      How to join these two tables as you can see common key name is diffrent in both tables, Name and fullname.

       

      I don't want to rename my field of Full Name to Name.

       

      In sqls against any relational data base we can compare two columns irrespective of their column name. Is it possible in QLikview?