AnsweredAssumed Answered

Comparing two files/importing records

Question asked by mz5005 on Jan 20, 2018
Latest reply on Jan 24, 2018 by philmodjunk

I need to compare two copies of files to have a third one as result with all the latest records from both (based on timestamps).

The files consist of data from many tables brought together in one lay-out.

As a test to find the easiest way to accomplish what I want, I have exported (using the lay-out) three records from a testcopy.

Then changed data in these 3 records in the exported file (for test purpose).

I try to get these 3 records back imported using "Update existing records in found set", however this does not work: the target fields are greyed out even though the tables are related (see screenshot).

Changing "arrange by" to Custom Order doesn't make a difference.

 

Q1: what do I do wrong? And if it is not possible like this, why not?

Q2: if Q1 reply is not possible, then is the only way to go to make a script that replaces data table by table using

    "Update existing records"?

Attachments

Outcomes