Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a requirement where more than two tables are involved in joining.
For ex. Consider 6 tables like Table 1,2,..6
I have to left join between Table 1,Table 2,Table 3
I.e.,
Table 1
Join (Table 1)
Table 2
Join (Table 1)
Table 3
Similarly I joined remaining
Table 4
Join(Table 4)
Table 5
Join(Table 4)
Table 6
Now I have to consider union between Table 1, Table 2, Table 3 (Union) Table 4,Table 5, Table 6.
So I Considered like
Table 1
Left Join (Table 1)
Table 2
Left Join (Table 1)
Table 3
Concatinaton(Table1)
Table 4
Left Join(Table 4)
Table 5
Left Join(Table 4)
Table 6
But while Loading it is throwing error and not able to perform Concatination operation between those two group of tables (Table 1,2,3 with Table 4,5,6)
Please help me in this scenario.
May be you need this:
Table 1
Join (Table 1)
Table 2
Join (Table 1)
Table 3
Table 4
Join(Table 4)
Table 5
Join(Table 4)
Table 6
Concatenate(Table1)
LOAD *
Resident Table4;
DROP Table4;
May be you need this:
Table 1
Join (Table 1)
Table 2
Join (Table 1)
Table 3
Table 4
Join(Table 4)
Table 5
Join(Table 4)
Table 6
Concatenate(Table1)
LOAD *
Resident Table4;
DROP Table4;
Hi Sunny,
Thanks for your help.