Paste data from two Excel files into the fields below and click Process. Note that the first row of data should consist of field names.
'; $button = ''; } else if($_REQUEST['a_key_sel'] == null && $_REQUEST['b_key_sel'] == null) { echo 'Next, select the key fields from each dataset and click Compare.
'; $button = ''; } else { echo 'Select one of the buttons below to display the desired comparison.
'; $button = 'Comparison options:
Display records within A that are not within B: | |
Display records within B that are not within A: | |
Display records present in both A and B: |
There are no records within A that are not within B for the specified keys.
'; exit; } echo 'Records within A that are not within B: (Export)
'.$field.' | '; $export .= $field.','; } $export .= "\n"; echo '
'.$item.' | '; $export .= $item.','; } echo '
There are no records within B that are not within A for the specified keys.
'; exit; } echo 'Records within B that are not within A: (Export)
'.$field.' | '; $export .= $field.','; } echo '
'.$item.' | '; $export .= $item.','; } echo '
All records from both datasets are unique for the specified keys.
'; exit; } echo 'Records present in both A and B: (Export)
'.$field.' | '; $export .= $field.','; } echo '
'.$item.' | '; $export .= $item.','; } echo '