Question 1

v3.0 April 6th 2022

Accepted Answer

New Stuff:
 • Huge milestone: Entire project migrated to a new development platform paving the road for future exciting features
 • Significant performance boost specially noticeable on big comparisons - 30% faster in the standard test
 • Welcome comparisons on schedule - You ask we listen!
 • Welcome DB2 native connection (no need to download components extra)
 • Single data extract - You ask we listen!
 • Improved query editor screen (F12) with SQL syntax highlight
 • Multiple minor improvements on memory and thread management, error handling, navigation and user experience
Bugs fixed:
 • Some minor bugs and cosmetic changes

v3.0.1 2022-04-07
Improvements and bugs fixed:
Expanded support for encoding which prevented loading files.

v3.0.2 2022-04-08
Improvements and bugs fixed:
Fixed instability loading individual data sources.

v3.1.0 2022-07-17
Improvements and bugs fixed:
Find Values (F3) now has two new options to allow more flexibility search get to a specific cell: "case sensitive" and "exact match"
Fixed error on setting for case sensitivity on comparison engine
Other minor cosmetic changes

Question 2

v2.1 Nov 1st 2020

Accepted Answer

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.1.4 2022-03-09
Improvements and bugs fixed:
Fixed failure exporting data from source B
Fixed error message while searching for values when no differences are shown on screen

v2.1.3 2021-12-31
Improvements and bugs fixed:
Fixed instability on column key picked when comparing all on a single step
Fixed crash on multiple clicks on column  or empty spaces on lists for keys and to be ingored
Favorites now load after double click from list
Full row count is now shown after a simple data extract
 
v2.1.2 2021-04-25
Improvements and bugs fixed:
Now "match by name" from column mapping is not case sensitive.
Column matching by name wasn't working when there were more columns on source B
 
v2.1.1 2021-03-14
Improvements and bugs fixed:
Fixed unitability on resizing columns when result grids are empty.

Question 3

v2.0 May 3rd 2020

Accepted Answer

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

Question 4

v1.5 October 15th 2019

Accepted Answer

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 {|,#	;} (pipe, comma, sharp, tab, semicolon)
Fixed bug on repeated key counts
Fixed minor cosmetic issues

Question 5

v1.4 October 31st 2018

Accepted Answer

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.

Question 6

v1.2 August 2nd 2018

Accepted Answer

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

Question 7

v1.1 July 8th 2018

Accepted Answer

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.

Question 8

v1.0 June 6th 2018

Accepted Answer

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.

Let us know about that feature you need

JuxtAPPose Standard

JuxtAPPose FREE

Compare data made easy