ESdat Forums
»
Forums
»
ESdat
»
Post-Import Calculations
Rank: Member
Groups: Registered
Posts: 11 Location: Calgary
|
Hello, I'm trying to use post-import custom calculation 10 to convert nitrate as N to nitrate as NO3-. I am receiving the error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again.' Some of my results do have both nitrate as N and nitrate as NO3 from the raw lab data but most of them only have nitrate as N. I don't need ESdat to calculate and overwrite the locations where the nitrate as NO3 data already exists. I looked at the raw query and it looks like it is only supposed to operate on samplecodes where the parameter to be calculated is null so I'm wondering if something else is causing this message? What else should I look for? Thank you, Theresa
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hi Theresa, The post import calc is designed to operate as you describe (calculate Nitrate as NO3 from Nitrate as N, only where Nitrate as NO3 doesnt already exist for that sample). I've tested that calc with a mix of some samples with Nitrate as NO3, and some without, and can't replicate the error. Would you be able to zip and send a database illustrating what you are seeing to support@ESdat.com ? Many thanks, Warwick
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Post-Import Calculations
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.