ESdat Forums
»
Forums
»
ESdat
»
Merging rows in chemistry tables
 Rank: Newbie
Groups: Registered
Posts: 5
Thanks: 1 times
|
Hi, In ESdat desktop, it is possible to produce a table that has all results for the same sampled date and location in a single row, even if the data are across multiple SampleCodes. When we try to do the same thing in ESdat online it comes out with multiple rows (one for each SampleCode). Is there any way to merge the data into a single row for each Location/Sampled_Date combination in ESdat online? The export table function of ESdat Desktop has been broken for a while so we no longer have this option. Thanks!
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 5
Thanks: 1 times
|
To give some context, on many of our major projects we report on field parameters and laboratory results in the same table and don't want to have 2 rows for each sample. We also have sites with large volumes of historical data, sometimes across multiple SampleCodes for the same sample.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Posts: 17
Location: EScIS
Was thanked: 3 time(s) in 3 post(s)
|
Hi Michael,
This is because the sample codes for the field and lab samples are different – this is unique and will determine which row a sample is shown on. Moving forward, if your lab is willing to include the field data in your lab report using the same Sample Code as their lab data, then this should certainly present the data on the same row in the Chem Tables.
Kind regards,
Claire
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Merging rows in chemistry tables
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.