Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could you clear me the below Question?
I have five tables 1,2,3,4,5 and fields name as below
Table 1 :
A,
B,
C
Table 2:
B,
C,
D,
Table 3 :
C,
D,
E,
F,
Table 4:
f,
g,
h,
i
Table 5:
A,
B,
G,
H,
I
All table have more than one or two same column name with each other table. In this case will join works or how to built a data model. I need output from al 5 tables
Hi Prabhu,
The Join will create a table with all possible combinations. Try something like this:
MasterTable:
NoConcatenate
Load
A,B,C
Resident
Table1;
join
load
B,C,D
Resident
Table2;
join
load
C,D,E,F
Resident
Table3;
...
drop tables Table1, Table2, Table3, ...;
If you want to exclude records that didn't match with the previously loaded table, consider using the left join.
I often use join, inner join and left join in one hit, depending on what I want to achieve.