How to Concatenate when we have more than two tables to join

[#1]

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.

[sunny_talwar · Accepted solution]

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;

[#3]

Hi Sunny,

Thanks for your help.