2 Replies Latest reply: Dec 19, 2016 4:25 AM by Umamaheswara Reddy RSS

    Join two tables in script

    Neha Saxena

      Hi All,

       

      I am getting strange issue while joining two tables in script. There are not all fields common in both the tables.

       

      There is status field in Table 1 and there is transactiontype field in table 2. After join I should get single row like below -

      Transaction KeyStatusTransactionType
      11InForceNew

       

      But I am getting two rows in qlikview (see attached image).

       

      In SQL Database I am getting single row while doing join on transaction key. How to get same output in Qlikview ?? Please help me with Join Syntax.

       

      Best Regards,

      Neha