Jump to content

Merge two sets of Columns in to one

Recommended Posts

Hello I have two sets of data, basically like this

Time-1 | DATA-1 and Time-2 | DATA-2

I want to transform these two columns in to one like



Time-ALL is basically the combination of Time-1 and Time-2 tracking the DATA rows.

I need to do this so I can plot the two data on one line chart with Time-ALL on the x-axis.


Thank You

Link to comment
Share on other sites

So you just need to define the relationship between the 2 data tables so that Spotfire knows how to join them.


Your example data is a bit unclear with respect to exactly how Time-ALL combines Time-1 and Time2. And how is the data related. Is it just a row number matching If you can clarify that, then it should be very clear how to implement this in Spotfire.

Link to comment
Share on other sites


The Time series are different, one is in months and the other is in days the only way to join them is to actually copy and paste one at the end of the other data so they are one column. There is no common data between these two time series. But I have lots of these data. How do I plot these two data on one chart

Link to comment
Share on other sites

  • 1 month later...
If the Time columns do not match ... and the two tables match by rows ... then just add a transformation to include a new colum defined by rowid() into each of the data sets.. You can then Insert the Data-2 column from the 2nd data set into the first data set by matching on this new column.
Link to comment
Share on other sites

  • 3 years later...

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...