Import error capture

[JGF]

I am import/updating records on match and I need to capture the records that do not match, so I can manually match/update them. How can I do this?

[dkemme]

Create a calculation field, number, count (relationship::anyfield), where relationship is the match you are needing. This will place a 0 where no match exists or the number of matches found. The you can find for 0 to find non-matching records.

[JGF]

The only problem is that I am updating on import, so if it does not match, where does the data go? It is the data that does not get updated that I am concerned about.

[-Queue-]

If imported records do not relate to existing ones, and 'add remaining records' is not specified, then the unrelated ones stay where they are.

I would suggest using IsEmpty(relationship::serial) also, which is faster than Count( ).