Join two tables in script

[nehasaxena]

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]

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

[#3]

Hi Neha,

Can you share sample data

Mean while use below

Table1

Left Join

Table2

or

Table1

Left Keep

Table2

or

Table1

Inner Join

Table2

so you can get your expected values