Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Make it F as A and reload mapping will happen.
regards,
nandha
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.
Its very easy and simple. Make C as A in script and reload.
Regards,
Nandha
Rename A from Table 1 as F and C from Table 2 as F.
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