Jump to content

Importing: Adding values rather than overwriting them


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

Recommended Posts

Hi Everyone,

 

I'd greatly appreciate your help - I've got 2 excel files that I want to import into my DB. When I import the data into FM, I would like FM to add the figures together rather than overwrite them.

 

For example:

on file1.xlsx    Dave = 6

on file2.xlsx    Dave = 4

I would like to import both files, and to end up with Dave = 10, but all i can do is get FM to overwrite the data, so that I get either 6 or 4.

Is this possible?

Many thanks,

Link to comment
Share on other sites

1 hour ago, Slater said:

Is this possible?

It's not possible the way your describe, but you could import the data from file1 into two fields (Name and Value1) first, then import the values from file2 into a Value2 field (while matching on Name), and use a third field (a calculation field) to add the two up.

Edited by comment
Link to comment
Share on other sites

This topic is 3000 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
×
×
  • Create New...

Important Information

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