Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nehasaxena
Creator II
Creator II

Join two tables in script

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

2 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable

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