How to Merge 2 table into 1 table

[eddykwan_]

Hi everyone,

Please help me how to merge 2 table into 1 table.

My expectation is :

I want to use this script in data load editor but its not successfull 

Please help me to solve this problem.

Thank you

[fallenangel6]

you can use a join to combine both tables if there is any primary key available.

[Or]

The error message here seems pretty clear - it seems there is no field named Sell in your Excel file (and in the appropriate sheet). If you are trying to create a calculation based on information in two different sheets, you need to join the two tables first, and then create the calculation in a new Load section based on the joined result:

JoinedTable:

Load * From Table1;

JOIN Load * From Table2;

FinalTable:

Load *, Sell+Production as CalculatedFieldSample

Resident JoinedTable;

Drop Table JoinedTable; // No longer necessary since FinalTable contains all the fields

[eddykwan_]

Hi Or,

Thanks for your reply.

So from your logic, I have to create a new table "JoinedTable" ?

[sidhiq91]

@eddykwan_ Yes as @Or  mentioned first Join both tables and then create a calculated field.