topic Re: How to Concatenate when we have more than two tables to join in App Development

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

Thu, 04 Aug 2016 11:06:50 GMT

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.

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

sunny_talwar — Thu, 04 Aug 2016 12:28:45 GMT

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;

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

Fri, 05 Aug 2016 06:04:24 GMT

Hi Sunny,

Thanks for your help.