Jump to content

help needed combining files


steveo123
 Share

This topic is 5651 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Create a relationship from one file to the other, based on the field determining uniqueness (if more than one field is required, create a concatenated calculation field in both files and then a relationship between them). Then, in the file with the relationship, call it fileA, create a script

Find All

Go to Record/Request/Page [First]

Freeze Window

Loop

If [isEmpty(relationship::keyfield)]

Go to Record/Request/Page [Exit after last, Next]

Else

Omit

End If

Exit Loop If [not Status(CurrentFoundCount)]

This will leave you with a found set consisting of only records which do not exist in the other file, according to the field(s) determining uniqueness. From the other file, fileB, you can then import the found set.

Note that you may need to update the serial (if there is one) for the imported records, if any of them match an existing serial in fileB. If this is necessary, be sure to update any child records which use the serial to link to a parent in fileB.

Link to comment
Share on other sites

This topic is 5651 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.