topic Join two tables in script in QlikView

Join two tables in script

nehasaxena — Mon, 19 Dec 2016 09:12:54 GMT

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 Key	Status	TransactionType
11	InForce	New

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

vinieme12 — Mon, 19 Dec 2016 09:24:46 GMT

post your script please, this is definitely joining on more than one field

Mon, 19 Dec 2016 09:25:50 GMT

Hi Neha,

Can you share sample data

Mean while use below

Table1

Left Join

Table2

Table1

Left Keep

Table2

Table1

Inner Join

Table2

so you can get your expected values