Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Try to use resident load from DB1-join-DB2 with noconcatenate.
When do ur transformation and drop temp tables (DB1-join-DB2).
Sergio S.