R
Robert1
I am trying to compare two datasets in the same worksheet.
Each data sets will have four key variables. The First two are
identifiers,
the 4th is an output. The third is the text message associated with the
2nd identifier. The dataset in all cases will be
sorted by the first two identifiers: CheckID, CustomerID, and the (4th
variable)
the output. There will be missing records from either datasets. Both
datasets are the same,
except one is dated, and represented as OLD, the other as new.
I am trying to compare or identify for new records in the New Datasets,
and Missing records in the New Datasets. This will be represented
as Removed or New Records. Because of the fact that there will be
missing records in either datasets, and the data is sorted by three
variables,
the rows won't be exactly a match. There may be less in the "New"
dataset.
How can a comparison identify for new & removed records in the 2nd
("NEw") Dataset?
I've written IF statements to compare the for this, but I can
compensate or adapt
for different number of rows for each dataset. Ideally, perhaps this
can be
done through Microsoft Query as a union join, and filtered for two
criteria:
"New Record" or "Deleted Records" (and perhaps "Changed Records")?
I know there are a couple of macros or conditional formatting that can
compare ranges, but I am not sure it solves for this situation.
Thanks.
Robert1
Each data sets will have four key variables. The First two are
identifiers,
the 4th is an output. The third is the text message associated with the
2nd identifier. The dataset in all cases will be
sorted by the first two identifiers: CheckID, CustomerID, and the (4th
variable)
the output. There will be missing records from either datasets. Both
datasets are the same,
except one is dated, and represented as OLD, the other as new.
I am trying to compare or identify for new records in the New Datasets,
and Missing records in the New Datasets. This will be represented
as Removed or New Records. Because of the fact that there will be
missing records in either datasets, and the data is sorted by three
variables,
the rows won't be exactly a match. There may be less in the "New"
dataset.
How can a comparison identify for new & removed records in the 2nd
("NEw") Dataset?
I've written IF statements to compare the for this, but I can
compensate or adapt
for different number of rows for each dataset. Ideally, perhaps this
can be
done through Microsoft Query as a union join, and filtered for two
criteria:
"New Record" or "Deleted Records" (and perhaps "Changed Records")?
I know there are a couple of macros or conditional formatting that can
compare ranges, but I am not sure it solves for this situation.
Thanks.
Robert1