Jump to content
We've recently updated our Privacy Statement, available here. ×

Combine tables into one master (merge by rows)


Kristoffer Jensen

Recommended Posts

Hi,

I have two identical tables one for with pull from our internal system and one which is the same with manual data.

I want to merge these two into one in spotfire, enabling me to have one *MASTER' to work from.

My issue is that when I use the Add rows function, and change the manual table in my raw data and hit refresh it wont get updated

How can I ensure that when I refresh my spotfire data it takes date from both tables and do the merge

I hope this makes sense

Thanks

Link to comment
Share on other sites

Join the two tables by using Column function and see if it works. I developed a report using two Views.One from the DB and the other from excel file local pc.Spotfire has a tool called ADS, my company has the ADS tool. So I used the ADS to create a view using my excel file as datasource, then create info link for each View, after that I use the Column function to join the two Views. I have done it for 3 different reports with no problems. Check the ADS tool out.
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...