Calculations post joining data from 2 databases

[nagarajan_iyer]

I have a situation here. I pulled data from 2 different database and joined them using "Left keep" formula. 

Post this i wanted to do few calculations wherein i need data points from both the database. I tried creating a new table and loading the datapoints from both database but wasnt able to do so. Any help would be appreciated. 

[jensmunnichs]

Could you post the script you have so far? And what kind of calculations are you trying to do?

[nagarajan_iyer]

Connect ... // Connect to the first database/server

Table1:

Load ...

Select ...

From (table in first database); 

Connect ... // Connect to the second database/server

Left Join (Table1)

Load ...

Select ...

From (table in second database);  

this is my original script

Now i wanted to do calculations which involved data from both database and hence i have joined then (using the keep function) 

eg: Amount from database 1- amount from second database

Eg: date from database 1- date from database 2 as remaining days

i am unable to do this and need some guidance. 

[sergioskv]

Try to use resident load from DB1-join-DB2 with noconcatenate.

When do ur transformation and drop temp tables (DB1-join-DB2).

Sergio S.