logo
    Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Jufar  
#1 Posted : Friday, July 14, 2017 5:29:50 AM(UTC)
Jufar
Rank: Member

Reputation:

Groups: Registered
Posts: 22

Thanks: 2 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

NickT  
#2 Posted : Friday, July 14, 2017 1:43:49 PM(UTC)
NickT
Rank: Newbie

Reputation:

Groups: Registered, Administrators
Posts: 7

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

 

Jufar  
#3 Posted : Saturday, July 15, 2017 4:23:46 AM(UTC)
Jufar
Rank: Member

Reputation:

Groups: Registered
Posts: 22

Thanks: 2 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

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

Reputation:

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

Was thanked: 5 time(s) in 5 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 

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: Member

Reputation:

Groups: Registered
Posts: 22

Thanks: 2 times

Hi Warwick,

It worked.  Thank you!

Jufar

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.