Linking 3 Different tables in load script

[#1]

Hi Frnds,

I have small problem. I have 3 different tables. in the 3rd table one column data are common in another 2 tables.

Here below i have shown a sample tables. here are Tables 1,2,3. If  you notice in Table 1 & 2 the Column A & C data will be in Table 3 Column F. So Kindly help how to link the Table 1 & 2 with Table 3.

Thanks In Advance

Regards,

Vignesh

For example,

Table 3:

F	D
456	Aaeratfhg
12	Ashg
789	Asfdgb
13	A
414	A
14	A
4	A
15	A
6	A
5	A
212	A
5486	A
5485	A
21523	A
8566	A
1	sdfghn
2	srty
3	tyht

Table 2:

C	D
212	ADS
5486	FND
5485	GRG
21523	HRE
8566	FDB
1	FCB
2	FBI
3	CIA
4	DGR

Table 1:

A	B
12	aaa
13	bb
14	fgg
15	thg
16	sdfeg

dxfghfxghxfgh

]

table @:

[happydays1967]

Vignesh, what should the final result look like?

HP

[Gysbert_Wassenaar]

Table 3 and 2 will be linked on field D. If field A in table 1 is the same as field F in table 3 then rename A to F so tables 1 and 3 will be linked on that field.

[#4]

Hey Gysbert,

Likewise i need to link all the there table using Field A,C & F. Because for example i showed this table. but in real time the fields are different. I do have link Table 1 & 3 by renaming the field name, but likewise if i do for the Table 2 & 3 am getting Sync error. so how to avoid this issue. kindly help wit5h this.

Thanks in advance

[Anonymous]

Hi Vignesh,

As said by Gysbert qlikview is a associative model tool. If the table or field names are similar it will automatically link the tables. If field A and F are similar rename A to F tables 1 and 3 will automatically linked.

Regards,

Nandha

[#6]

[#7]

[#8]

Here u can see the three table... i dono how to insert the app with this doc. that's y took screen shot.

Kindly help with this Frnds..

[Anonymous]

Vignesh,

Rename any one of the field in rest of the two table to map each other.

Regards,

Nandha

[Anonymous]

Vignesh,

Go to your load script and change the F name as A

Like : F as A

then the mapping happend.

Regards,

Nandha