M
msnyc07
I have a table with many rows and duplicate values.
However 'Remove Duplicates' won't work since I need some rules to process
i.e. which records to remove and in some cases I want to combine.
For instance;
If I say Field1 and Field2 define duplicate records I don't want it to just
throw away the first dupe it finds. I want it to keep the record that has a
specified value in FieldC say SourceField<>"" or SourceField="Wikipedia"
Alternately I may want to merge specific fields say if Record 1 has 'Blue'
in Color and Record 2 has 'Red' in color I don't want it to use first but to
concatenate so new/merged field has Red; Blue
Is that something that exists as either code or plug-in that anyone knows
of? I can't be the only one that needs more then just 'remove duplicates'...
However 'Remove Duplicates' won't work since I need some rules to process
i.e. which records to remove and in some cases I want to combine.
For instance;
If I say Field1 and Field2 define duplicate records I don't want it to just
throw away the first dupe it finds. I want it to keep the record that has a
specified value in FieldC say SourceField<>"" or SourceField="Wikipedia"
Alternately I may want to merge specific fields say if Record 1 has 'Blue'
in Color and Record 2 has 'Red' in color I don't want it to use first but to
concatenate so new/merged field has Red; Blue
Is that something that exists as either code or plug-in that anyone knows
of? I can't be the only one that needs more then just 'remove duplicates'...