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 @:

[Anonymous]

Make it F as A and reload mapping will happen.

regards,

nandha

[#3]

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.

[Anonymous]

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

Regards,

Nandha

[#5]

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

[Anonymous]

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