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


      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,