AnsweredAssumed Answered

importing records and updating

Question asked by bank247 on Aug 29, 2018
Latest reply on Aug 29, 2018 by philmodjunk

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.

 

record:

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. 

Outcomes