AnsweredAssumed Answered

Handling a 'mixed field'

Question asked by tays01s on Jan 11, 2015
Latest reply on Jan 11, 2015 by philmodjunk

Title

Handling a 'mixed field'

Post

I have a 'table' I'd like to import from Excel. It has ~55 fields and 100 records of standards for the different 55 parameters. Most fields are just 'static' numeric. However, there are quite a few that contain formulae. I think I can handle these during Import into FM. I can use an Excel VBA macro to adjust syntax in preparation for the FM import. However, 1 problem: Some fields contain both static numbers and formulae, sometimes 2 different formulae.

It's important to keep this Excel spreadsheet as a link to the raw data, but how do I deal with these mixed fields in FM? ie. how do I deal with it while permitting an efficient import from Excel?

Outcomes