topic Re: Linking 3 Different tables in load script in QlikView

Linking 3 Different tables in load script

Thu, 02 Jul 2015 11:29:33 GMT

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

Re: Linking 3 Different tables in load script

happydays1967 — Thu, 02 Jul 2015 11:40:19 GMT

Vignesh, what should the final result look like?

Re: Linking 3 Different tables in load script

Gysbert_Wassenaar — Thu, 02 Jul 2015 11:44:14 GMT

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.

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 11:57:36 GMT

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

Re: Linking 3 Different tables in load script

Anonymous — Thu, 02 Jul 2015 11:59:54 GMT

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

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 12:03:58 GMT

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 12:05:32 GMT

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 12:09:43 GMT

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..

Re: Linking 3 Different tables in load script

Anonymous — Thu, 02 Jul 2015 12:10:28 GMT

Vignesh,

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

Regards,

Nandha

Re: Linking 3 Different tables in load script

Anonymous — Thu, 02 Jul 2015 12:14:54 GMT

Vignesh,

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

Like : F as A

then the mapping happend.

Regards,

Nandha

Re: Linking 3 Different tables in load script

Anonymous — Thu, 02 Jul 2015 12:15:47 GMT

Make it F as A and reload mapping will happen.

regards,

nandha

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 12:34:19 GMT

Okie i can link the Field F & A by rename F as A, But i do also want to link Field C with F... in such case what would the solution.

Re: Linking 3 Different tables in load script

Anonymous — Thu, 02 Jul 2015 12:38:14 GMT

Its very easy and simple. Make C as A in script and reload.

Regards,

Nandha

Re: Linking 3 Different tables in load script

Thu, 02 Jul 2015 12:41:54 GMT

Rename A from Table 1 as F and C from Table 2 as F.

Re: Linking 3 Different tables in load script

Anonymous — Thu, 03 Sep 2015 13:33:46 GMT

Hi Vignesh,

You can try below steps to do your job :

1) To link table 1, table 2 table 3, you need to have at least one common column with same column name.

2) You need to rename column in such a way that all three table has same common column name.

3) You can alias columns.

4) You can use QUALIFY - UNQUALIFY.

Thanks

Sattya