Importing: Adding values rather than overwriting them

[Slater]

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,

[comment]

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 December 14, 2015 by comment

[Slater]

Thanks Comment, much appreciated that you responded!

What I might do instead is take your advice, but do that in a dummy DB, export the total data to a csv and then import that into my real DB.

Cheers

[comment]

2 hours ago, Slater said:

export the total data to a csv and then import that into my real DB.

Why not import directly from the "dummy DB" (which could be just a table in your existing file)?