Jump to content

Comparing Two Data Sets


Brian C

Recommended Posts

Hello,

Does anyone have any ideas on how I can compare two different data sets in Spotfire I have two Excel sheets, one from this month and one from last month that both contain the same 20 columns but around 50,000 rows. The data in these rows vary month tomonth. Is there a solution on how I can find these differences using Spotfire

I created a solution using Access but unfortunately my boss is looking to house the entire processin Spotfire in order to share the results across the company.

Thanks!

Link to comment
Share on other sites

Do you want to compare distributions You could simply append one dataset to the other and add a 'flag' column to indicate the origin, then visualize with barcharts or boxplots colouring or groupingby the flag column. Otherwise please elaborate on your Access solution.

Gaia

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