merge 2 tables

[mazacini]

Hi

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

[kaushiknsolanki]

Hi try this.

     Load * from Table A;

     Concatenate

     Load * from Table B;

Regards,

Kaushik Solanki

[mazacini]

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

[kaushiknsolanki · Accepted solution]

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