Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Help merging some imported records


cquante
 Share

Recommended Posts

I have an existing database with the following fields. LOT NUMBER, LOT SOLD

 

I want to import a tab delimited file that will contain two fields Lot Number and Sold

 

The Lot number in the original database is all the lots in an auction. Say lots 1 to 100

 

The lot number in the imported field will be just the lot numbers that sold, and the amount it sold for.

 

So, the imported fields may have say lots 1,2,5,6,8,9 and the corresponding amount each lot sold for.

 

I want to be able to import the records, compare the lot number in the imported record and if it matches the lot number in the database, fill the LOT SOLD field with the amount that was imported as Sold.

 

I hope that makes sense.

 

I need some help with the scripting.

 

Thanks,

 

Charlie

Link to comment
Share on other sites

You don't need any scripting.

 

• import the file into a new table

• create a relationship between the existing table and the import table by LotNumber

• go to your existing table and Show All Records

• apply Replace Field Contents to the LotSold field, using the calculation ImportTable::LotSold (simply a reference to the related field)

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use