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

Notification

Icon
Error
data output
Options
Go to last post Go to first unread
Previous Topic Next Topic
justin  
#1 Posted : Thursday, September 27, 2018 4:50:48 PM(UTC)
justin
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1

Hi, we have an ESdat Access dataset with a large number of samples (i.e. Field IDs) and Chem Groups.  Due to the restriction on number of columns we cant output all data in a single table. 

I have outputted several tables for several different Chem Groups but am unable to combine the tables easily as the Field IDs do not line up (i.e. not all samples/Field IDs have same chem groups).

Is there a way to output all Field IDs including blank/null values for the specific Chem Groups? This way all the rows will line up in the tables we generate.

Hope this makes sense.

Thanks,

Justin

Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Wednesday, October 3, 2018 8:08:50 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 Justin,

Sorry there is no magic answer, Access databases have their limitations.  If you want to produce very large tables you would need to look at the Server version of ESdat.

Warwick
Back to top
WWW
Similar Topics
Field and Lab data output in seperate columns (ESdat)
by Babs 2/18/2012 1:58:04 AM(UTC)
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