Joining

Thu, 25 Aug 2011 06:34:55 GMT

TableA:

orgcode	orgname	Orgtype	address
1	tata	Mnc	aaa
2	birla	Mnc	bbb
4	jindal	Mnc	ccc

TableB:

Personcode	title	firstname	lastname
1	dr	Sandeepa	Rout
2	mr	Debashish	rout
4	dr	Surekha	Nayak

TableC:

Orgcode	Personcode	Primaryaddress
1	1	xx
2	2	yy
4	4	zz

Table1:

Orgcode	Orgname	Orgtypename	Address
1	Tata	Mnc	aaa
2	Birla	Mnc	bbb
3	L&T	Mnc	eee
4	Jindal	Mnc	ccc
5	Adani	Mnc	ddd
6	Wipro	Mnc	fff

Table2:

Personcode	Title	Firstname	Lastname
1	dr	Sandeepa	Rout
2	mr	Debashish	Rout
3	dr	Sandeep	Sahoo
4	dr	Surekha	Nayak
5	dr	Abhimanyu	Rout
6	dr	Laxmipriya	Nayak

Table3:

Orgcode	Personcode	Primaryaddress
1	1	xxx
2	2	yyy
3	3	aaa
4	4	zzz
5	5	bbb
6	6	ccc

Output should be:

Personcode	tableA.orgcode	Table1.orgcode	tableA.orgname	Table1.orgname	matched
1	1	1	Tata	tata	matched
2	2	2	Birla	birla	matched
3	--	3	--	L&T	unmatched
4	4	4	Jindal	jindal	mathced
5	--	5	--	adani	unmatched
6	--	6	--	wipro	unmatched

It means 1st we have to join tableA, tableb, tablec to one(tabA). Then table1, table2, table3 to one (Tab1).

Then we have to compare TabA and Tab1.

But We have to compare orgcode against personcode.

Also we have to create a listbox as Matched where two options should be displayed. If we will click on matched or unmatched it will display accordingly..

Please note: the matched field in output table is a label not a predefined field..

Kindly suggest what to do...

Re: Joining

Thu, 25 Aug 2011 10:25:34 GMT

anybody??

Joining

klausskalts — Thu, 25 Aug 2011 13:50:15 GMT

When you join you need to find the data fields which you want as key values when you perform your join.

These data fields MUST be named with the same name.

All other fields MUST have different field names.

LEFT JOIN, RIGHT JOIN AND INNER JOIN works fine ......

topic Joining in QlikView

Joining

Re: Joining

Joining