Jump to content

Actuals versus Forecast Join

Katie Sikorski

Recommended Posts

I have a table that contains Well information another table that has actual production and one that has forecast. Is there a way to Join all three together into one to Show Well, Actual Production then Forecast after actuals in Spotfire. I have tried Joining one then the other and then making an information link but it does not come out right I am trying to make this plot
Link to comment
Share on other sites

If you have all three tables in your dxp file then you can join the tables by going to your data canvas and select "Add columns" when you click on the little (+) icon.


When the dialog window opens, you'll find your data in analysis under "Other".

The go thru the "settings for added columns".

I expect the table with the well information contains all of the wells. So, I would add the the columns from the actual production table and from the forcast table to the well information table. You probably have some kind of well id column to join the the tables (matching columns). Aleft outer join (which should be the default join) should be the correct join method for you.

Link to comment
Share on other sites

Sorry, I can't help here. Never worked with information links.


But as long as you have your tables in your dxp file you can to this kind of table merge. It doesn't matter where the data was coming from. I'm pretty sure that you can join your tables with information links as well

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...