Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Duplication on standards
Options
Go to last post Go to first unread
Previous Topic Next Topic
Jufar  
#1 Posted : Friday, July 14, 2017 5:29:50 AM(UTC)
Jufar
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 34

Thanks: 4 times

Hi,

I exported a table for vapour standards.  I got duplicates (ie. chloroform standard 1|1).  I'm not sure why it is doing that.  I just switched to a windows 10 (64bit) and excel 2013 (32 bit) recently.  Is there a way to eliminate the duplication?

Jufar
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
NickT  
#2 Posted : Friday, July 14, 2017 1:43:49 PM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Jufar,

What do you mean by exported a table for vapour standards?  I assume you've generated a chemistry table with vapour environmental standards. Is this correct?

What environmental standards have you selected for your export?

Depending on the standard that you have selected, there may be multiple values for a single analyte (such as chloroform) which are dependant on other parameters (such as pH ranges or hardness).

Thanks,

Nick

 

Back to top
WWW
Jufar  
#3 Posted : Saturday, July 15, 2017 4:23:46 AM(UTC)
Jufar
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 34

Thanks: 4 times

Hi Nick,

It's happening to all the standards we are exporting.  Example is having a full table of standards looking like this, "30|30, 200|200, 500|500, 0.1|0.1, 600|600|600".  

So they are repeating themselves, even though there are no dependencies.  Is there a way to avoid that or fix the issue?

Jufar
Back to top
Warwick Wood  
#4 Posted : Saturday, July 15, 2017 7:35:49 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Jufar,

You probably have those values in the zRef_Environmental_Standards table twice if they are outputting twice.  If you delete one of the values that should resolve what you are seeing.

Warwick 
Back to top
WWW
thanks 1 user thanked Warwick Wood for this useful post.
Jufar on 7/18/2017(UTC)
Jufar  
#5 Posted : Tuesday, July 18, 2017 2:55:11 AM(UTC)
Jufar
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 34

Thanks: 4 times

Hi Warwick,

It worked.  Thank you!

Jufar
Back to top
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.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET