3 Replies Latest reply: Sep 11, 2016 5:12 AM by Chanty 4u RSS

    Two Tables with Same Field Names

    Mohammad Sarif

      Hi Experts,

      I have one doubt.  Lets Assume a scenario like I have 2 tables names Customer and Customer New. Both have same fields CustID and CustName.

       

      If I use below script:

       

      Customer:

       

      LOAD [Cust ID],

           [Cust Name]

      FROM

      [Two Table with Same Field Names.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      Customer_New:

       

      LOAD [Cust ID] ,

           [Cust Name]

      FROM

      [Two Table with Same Field Names.xlsx]

      (ooxml, embedded labels, table is Sheet2);

       

      It is not producing 2 table in Qlik. Rather it is creating only one table called Customer. As per my knowledge it should create 2 tables with synthetic key. Please explain. So that I can understand Qlik better.

       

      Thanks,

      Sarif