Katie Sikorski Posted February 28, 2022 Share Posted February 28, 2022 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 More sharing options...
Fabian Duerr Posted February 28, 2022 Share Posted February 28, 2022 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 More sharing options...
Katie Sikorski Posted February 28, 2022 Author Share Posted February 28, 2022 Will this work if the table are SQL tables made into information links Link to comment Share on other sites More sharing options...
Fabian Duerr Posted March 2, 2022 Share Posted March 2, 2022 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now