Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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

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.

1 Solution

Accepted Solutions
MVP
MVP

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

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;

2 Replies
MVP
MVP

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

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;

Not applicable

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

Hi Sunny,

Thanks for your help.