Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi try this.
Load * from Table A;
Concatenate
Load * from Table B;
Regards,
Kaushik Solanki
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
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