topic Re: merge 2 tables in QlikView

merge 2 tables

mazacini — Mon, 22 Jul 2013 11:07:53 GMT

When I run my load script, I end up with 2 tables with exact same structure. How do I combine them into a single table. I want to append one table onto the other.

Thanks

Re: merge 2 tables

kaushiknsolanki — Mon, 22 Jul 2013 11:11:19 GMT

Hi try this.

Load * from Table A;

Concatenate

Load * from Table B;

Regards,

Kaushik Solanki

Re: merge 2 tables

mazacini — Mon, 22 Jul 2013 11:19:43 GMT

Hi Kaushik,

I don't think I can do that. Let me explain.

Here is my script....

Table1:

Load A,B,C from....

Table2:

Load A,B,D,E from ....

Left Join (Table2)

Load A,

D+E as C

Resident Table2;

Drop Fields D,E;

The result is that I have Table1 and Table2, both with fields A, B and C

Re: merge 2 tables

kaushiknsolanki — Mon, 22 Jul 2013 11:23:35 GMT

Hi,

Why are you using the left join to table2 when you can evaluate the C column from that only.

Something like this.

Table1:

Load A,B,C from....

Concatenate

Load A,B,D+E as C from ....

Regards,

Kaushik Solanki