Jump to content

Combining records


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

Recommended Posts

  • Newbies

I have similar records in one database that need to be combined into one record without using a portal. For example, db1 contains an ID and Name fields. These can have duplicated values (up to five records with the same ID). There are also fields for five other values, but this information was stored in a separate record for each of the five fields. How can I create one record that contains the ID, Name, and values for the five other fields?

Link to comment
Share on other sites

You might want to use a portal then run a script in the new DB that moves (Cut and Paste) the data from the portal and the appropriate related fields into a field in the new DB. Loop that through the new DB and then get rid of the portal and relationship to the old DB.

Of course the new DB needs to have records in it with each of the ID numbers for the portal to work. You can automatically create all the records with serialized ID numbers then after running the loop script above, find and delete the records that don't have any data in the new combined field. All of this will take a little fine tuning but should work well even if there are tens of thousands of records.

Cael.

Link to comment
Share on other sites

This topic is 7837 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.