Hey guys, so I have this working but at times I notice I'm getting duplicates or it may not be working the way I envision. Each of my records contains upwards of 40 fields but to simplify I think I can cram what I'm trying to do into a few lines.
field 1 - ID number
field 2 - status (A, B or C)
field 3-40 - random data
When I'm importing I do update matching records in found set and add remaining data as new records with
<-> on ID number.
Sometimes I get some duplicates or records hanging around (I notice them much later since I have about 40,000 records). - but if I understand the importing correctly it should be matching by ID number then field 2 should change to what the incoming import of records has and just updating the record not creating a new one correct?
field 2 will change every 2-3 days and I need a way to keep tabs on it.