2 Replies Latest reply: Jun 8, 2017 1:39 PM by Peter Cammaert RSS

    Can we Link tables with different column names ?

    charan kandimalla

      Hello,

       

      In qlikview if the two tables column name is same then system will automatically create a link then what about if the two tables has different column names but the data is same ?

       

      Assume below are the two tables and below of them are column names:

       

      Sales(table):

      Product_key,

      sales_id,

      customer_id,

      sale_Date,

      amount,

      qty

       

      Product(table):

      Product_id,

      Product_name,

      Mfg_Date,

      Product_type,

      Color

       

       

      The above two tables has column name called product_id(from product table) and product_key(from sales table). Logically both are connected but if we load these 2 tables

      system will not auto link these tables due to different names.

       

      Could any one please tell me how to connect these 2 tables with out changing the column names ?

       

      Thanks in Advance,

      Charan.