Column Data Comparisonmdi-hammer-wrenchToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractormdi-menu-downmdi-informationAboutmdi-phone-classicContactToolboxColumn Data ComparisonData TrimmerDelimiter SeparatorExtra New Line RemoverJSON Formatter and ConverterOnline HTML EditorPrefix and Suffix ModifierURL Decoder and EncoderXML File Data ExtractorXSD File Data Extractor
Comparemdi-compareClearmdi-delete
Selectmdi-select-allClearmdi-delete
Column Data Comparison
This tool compares data and returns results that involves data matching, left anti semi join or right anti semi join.
Usage
Selection for process.
Data Matching - compares two sets of data and returns matching values.
Row Data Matching - compares two sets of data and returns matching values by row.
Left Anti Semi Join - returns left data that do not match right data.
Right Anti Semi Join - returns right data that do not match left data.
Switch to enable or disable case sensitive checking.
Button to process the comparison of two columns
Button to clear the content of the coulmn A and B panel area.
Selection for displaying data.
Show All - Display all the values from the result.
Distinct - Remove all duplicates from the result.
Distinct Ignore Case - Remove all the duplicates regardless if they are upper or lowercase letters.
Button to select all the data in the result panel area.
Button to clear the content of the result panel area.
Column A panel area.
Column B panel area.
Result panel area
How to compare the two columns
Paste the data to the two columns, A(8) and B(9).
Select what type of process(1) to compare the columns.
Click the Compare button(3) to start comparing.
Result will display in the result panel(10).
Friendly Reminder: Before any database changes especially in production, please make a backup copy.
If you have a feedback or would like to request a new feature, please visit our Contact page.