ESdat Forums
»
Forums
»
ESdat
»
C6-C10l less BTEX (F1)
 Rank: Member
Groups: Registered
Posts: 10
Location: Dunsborough
|
Hi, after ordering analytes in the zRef_Chemistry_Lookup sheet, the output table comes out in the order for everything except "C6-10 less BTEX (F1)". This stays in the BTEX chem group. i.e. I've set it to be column no. 11, but it comes out in column 8 How can I break it out so it sits with the rest of the TRH fractions? cheers TobyS attached the following image(s):  Output.JPG (106kb) downloaded 27 time(s). Ordered.JPG (21kb) downloaded 26 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Posts: 259
Location: Ballina
Was thanked: 8 time(s) in 8 post(s)
|
Hello Toby, Please see http://www.ESdat.net/HandyHints.aspx#6 http://www.ESdat.net/forum/default.aspx?g=posts&t=23 Edited by user Wednesday, September 17, 2014 3:06:25 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 10
Location: Dunsborough
|
Hi Alex, thanks for the reply. the procedure I followed was as described in the links you posted, and as follows: 1. I numbered the groups in the order I wanted them to appear in the table in zRef_Chemistry_Lookup_Chem_groups 2. I numbered the analytes in the order I wanted them to appear in the table in zRef_Chemistry_Lookup 3. I then applied the filter for the output table. The issue I'm having is that one of the analytes was not in the order I programmed- i.e. it came out in column 8 rather than column 11.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498  Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hello Toby, Assuming you are grouping by Chem Group, the compounds will be grouped as described by their Chem Group value in the zRef_Chemistry_Lookup table (or zRef_Chemistry_Lookup_Profile in SQL Server version). ie it is likely that "C6-10 less BTEX (F1)". has a Chem Group value of "BTEX" ? Changing the chem order won't change the grouping. Regards, Warwick
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 10
Location: Dunsborough
|
Thanks Warwick. It is possible then to edit the Chem Group? i.e. can i view the group and take C6-10 less BTEX (F1) and add it to the TRH group?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 10
Location: Dunsborough
|
Figured it out, thanks Wariwick
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
C6-C10l less BTEX (F1)
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.