AnsweredAssumed Answered

Importing data script step problems

Question asked by sam0723 on Aug 14, 2017
Latest reply on Aug 16, 2017 by sam0723

Hello everyone, i am new to filemaker. i am trying to import data from excel file weekly using importing data script.

In the script step option, there are 3 options, Adding new record, updating existing record and updating matching record. In my case, add new record will create many duplicate records weekly, so i try to use the remaining options.


My target is to use the updated record and transfer the data using set field/set variable step to another table A according to the primary key.


The problem is when the whole script run the 2nd time, there are many duplicate records in table A.


so how could i determine which records are old records, which one are the new records?


is it impossible to compare the data to prevent creation of duplication records?


i am using filemaker 15


Sorry for unclear description.