topic Re: join from two tables using 3 fields!!! in QlikView

join from two tables using 3 fields!!!

Thu, 19 Jun 2014 09:13:21 GMT

Hi All

I have two tables.

with fields table1: id, field1

table2: recno,field1,field2

now i want the records those are match with table1.field1=table2.field1 and table2.field=100.

please help two write load script in qlikview.

Table1		table2
id	field1	recno	field1	field2
1	1	1	1	100
2	2	2	2	200
3	3	3	3	200
4	4	4	4	300
5	1	5	1	400
6	2	6	2	100
7	3	7	3	100
8	4	8	4	100
9	1	9	1	100
10	2	10	2	100
11	3	11	3	100
12	4	12	4	200
13	1	13	1	300
14	2	14	2	400
15	3	15	3	500
16	4	16	4	100

Re: join from two tables using 3 fields!!!

alexandros17 — Thu, 19 Jun 2014 09:24:32 GMT

My example

Re: join from two tables using 3 fields!!!

ashfaq_haseeb — Thu, 19 Jun 2014 09:25:30 GMT

Hi,

try below.

Table1:

load * Inline

[

id,field1

1,1

2,2

3,3

4,4

5,1

6,2

7,3

8,4

9,1

10,2

11,3

12,4

13,1

14,2

15,3

16,4

];

Table2:

inner join

load * Inline

[

Recno,field1,field2

1,1,100

2,2,200

3,3,200

4,4,300

5,1,400

6,2,100

7,3,100

8,4,100

9,1,100

10,2,100

11,3,100

12,4,200

13,1,300

14,2,400

15,3,500

16,4,100

]where field2=100 and Exists(field1,field1);

Regards

ASHFAQ

Re: join from two tables using 3 fields!!!

sureshbaabu — Thu, 19 Jun 2014 09:32:47 GMT

Hello,

You can do a 'Inner join Table2 with Table 1 and write the filter condition on Table 2

Table 1:

C1,F1

*,*

Inner Join(Table1)

Table2

C2,F1,F2

*,*,*

where F2=100

Hope this helps!!!

Thanks

Re: join from two tables using 3 fields!!!

Thu, 19 Jun 2014 10:25:22 GMT

Thank you ASHFQ Mohammad.