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

Warwick Wood  
#2 Posted : Wednesday, October 03, 2018 8:08:50 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

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

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

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.