Let us know about that feature you need

JuxtAPPose Standard

v1.0 June 6th 2018


Because compare data has never been fun, JuxtAPPose Standard came in it's first release to make the tedious task of compare query results and/or compare excel spreadsheets as easy and simple as possible, check out some of the features: • Source data: MS-SQL 2008 and later, Oracle 11g, Excel documents (.xslx) with no data size limit!
• Copy column headers: With a simple configuration you can copy the column headers from the grids.
• Key columns: You can use as many columns for your key as needed, RAM is the limit!
• Ignore columns: You can ignore as many columns as needed.
• Shrink results: Hide all columns with no differences by just selecting "Relevant columns only".
• Favorites: Need run the same comparison over and over again? Just hit that "star" icon and keep track of your most repeated comparisons.




v1.1 July 8th 2018


New stuff:

  • The position of the grids can now be switched from vertical to horizontal.
  • Screen resolution was extended to the display size.
  • Interrupt comparisons with the new "stop" button.
Bugs fixed:
  • All windows are now opened in the same physical monitor.
  • Fixed bug on cell selection with no differences.




v1.2 August 2nd 2018


New stuff:

  • Search specific values in the results
  • Microsoft SQL Azure
  • New query time out setting.
  • Enhanced descriptions, buttons, tool tips and behavior in controls.

Bugs fixed:
  • Default favorite not loading




v1.4 October 31st 2018


New Stuff:

  • Added "on difference" restriction for finding values.
  • Added fetch up and down for differences by column.
  • New 64bit ODBC driver support:
    • Amazon Redshift
    • MySQL (Connector 8.0)
    • PostgreSQL (Dirver v10)
    • MS-Access (*.mdb, *.accdb)
  • New support for DSN (This can be used to connect to any other database engine not listed above):
    • User DSN ODBC 64 bit
  • Increased timeout options.
  • Command timeout follows global timeout (timeout & execution).
  • Improved connection test experience.
  • Added sheet selection for excel files.
  • Enhanced descriptions, buttons, tooltips and behavior in controls.
  • Included rename on connections.
Bugs fixed:
  • Connection dropdown list sometimes wasn't being refreshed after adding new connections.
  • Connection selections lost after modifying the connection lists.
  • Grid content not refreshed after no differences found.
  • Minor bugs on using favorites.
  • Fixed crash on open files.
v1.4.3 2019-07-14 Improvements and bugs fixed:
  • Redesign of quick counts for better user experience.
  • Tool tips added to all quick counts for better understading of the UI.
  • Improved UI for managing favorites.
  • Fixed issue on loading empty sheets.
  • Fixed minor cosmetic issues.
v1.4.2 2019-01-06 Improvements and bugs fixed:
  • Support for batch statements (For queries that require creating temporary tables).
  • Improved error messages for empty sources.
  • Fixed issue on files locked after data extraction.
v1.4.1 2018-11-14 Bugs fixed:
  • Crash on comparison with no data extract.
  • Minor esthetic glitch on connection manager switching on different connections.
  • Minor esthetic display issue on results grids.




v1.5 October 15th 2019


New Stuff:

  • Welcome to CSV files (make sure the 1st row has the titles).
  • Native compatibility with Oracle 12c, 18c and 19c.
  • Added windows authentication for Oracle connections.
  • 35% faster load for excel files.
  • New features to instant jump to the differences found.
  • New settings for case sensivitiy.
  • New settings for auto cast text to number.
  • Improved detection of typos in the key and ignore column lists.
  • Improved UI for managing connetions.
Bugs fixed:
  • Files selected were reloaded when the connection manager is open and then closed.
  • Extract option is not pre-selected when a favorite is loaded.
  • Other minor cosmetic issues fixed.
v1.5.1 2020-01-28 Improvements and bugs fixed: Welcome to .txt files (make sure the 1st row has the titles) Data separators for flat files include {|,#\t;} (pipe, comma, sharp, tab, semicolon) Fixed bug on repeated key counts Fixed minor cosmetic issues




v2.1 Nov 1st 2020


New Stuff:

  • Logic filters (You asked we listened!).
  • The features Shrink Results (AKA "Main columns"), Fetch difference and Find (Ctrl + F) now also follow the rules from Logic Filters.
  • Introducing column mapping (You asked we listened!).
  • Improved "favorites", now it can store your settings from Logic Filters and column mapping.
  • Improved data export menu, now all result types included for data export.
  • Improvements on user experience for "custom key" and "columns to ignore" (thank you for your suggestions!).
  • User and password now are not mandatory for creating connections.
Bugs fixed:
  • Cancelled sheet selection was still picking the 1st tab.
  • Connection and test for MS-Access wasn't working propperly.
  • Refreshing a data extract after shrinking results (main columns) wasn't showing back all columns for the 100 rows data sample.




v2.0 May 3rd 2020


New Stuff:

  • Full rewrite of the comparison core with a BIG performance boost - 9.5X faster than JuxtAPPose FREE 1.5 (before there was no difference).
  • Export concidental universe (you ask and we hear!).
  • Export all rows where differnces were found.
  • Export unmatched rows.
  • Export repeated rows.
  • Data extraction can be cancelled.
  • New expandable text editor (you ask and we hear!).
  • New feature setting to deactivate the product key.
  • Improved load time.
  • Main user interface changed for a cleaner look.
  • Drastic improvment in general responsiveness.
  • Improved status messages.
Bugs fixed:
  • Blob handling.
  • Crash comparing empty files.
v2.0.1 2020-05-11 Bugs fixed: Key not found when auto cast to numbers is on for single column keys





JuxtAPPose FREE

v1.0 June 6th 2018


It's here! JuxtAPPose FREE was released to help you to compare excel spreadsheets quick and easy, these are some of the features it offers to help you analyzing data:

  • Source data: Excel documents (.xslx) for as much as 5MB.
  • Key columns: You can use as many columns for your key as needed, RAM is the limit!
  • Ignore columns: You can ignore as many columns as needed.
  • Shrink results: Hide all columns with no differences by just selecting "Relevant columns only".




v1.1 July 12th 2018


New stuff:

  • The position of the grids can now be switched from vertical to horizontal.
  • Screen resolution was extended to the display size.
Bugs fixed:
  • All windows are now opened in the same physical monitor.
  • Fixed bug on cell selection with no differences.




v1.2 August 5th 2018


New stuff:

  • Search specific values in the results
  • Enhanced descriptions, buttons, tool tips and behavior in controls.
  • Added demo window about settings.

Bugs fixed:
  • Default favorite not loading




v2.0 Nov 1st 2020


New Stuff:

  • Introducing column mapping (You asked we listened!).
  • Updated UI to match JuxtAPPose Standard look and feel.
  • Improvements on user experience for "custom key" and "columns to ignore" (thank you for your suggestions!).
Bugs fixed:
  • MS-Access connection test wasn't working propperly.




v1.4 October 31st 2018


New Stuff:

  • Added "on difference" restriction for finding values.
  • Added fetch up and down for differences by column.
  • Added sheet selection for excel files.
  • Enhanced descriptions, buttons, tooltips and behavior in controls.
Bugs fixed:
  • Grid content not refreshed after no differences found.
  • Fixed crash on open files
v1.4.0.1 2019-01-06 Bugs fixed:
  • Files locked after comparison.




v1.5 January 26th 2020


New Stuff:

  • New quick counts.
  • 30% faster file load.
  • Welcome to CSV files (Make sure the 1st row has the titles).
  • Instant jump to result/diff types by clicking on any of color code boxes.
  • New settings for case sensitivity.
  • New settings for auto cast text to numbers
Bugs fixed:
  • Minor cosmetic issues.





Compare data made easy

JuxtAPPose embrace the fact that today the data is not centralized and the task "validate data" might mean to compare query results vs excel spreadsheets or query vs query or spreadsheet vs spreadsheet or any permutation including different database engines.

  • Facebook - Black Circle
  • YouTube - Black Circle
  • Twitter - Black Circle

©2020 BY JUXTAPPOSE.