Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use a join to combine both tables if there is any primary key available.
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
Hi Or,
Thanks for your reply.
So from your logic, I have to create a new table "JoinedTable" ?
@eddykwan_ Yes as @Or mentioned first Join both tables and then create a calculated field.