Export as flat file

[livermd]

I need to convert and import relational data to flat data for use in a statistical program

I'm using relational DB with portals. I'm Following patient lab data over time.

In master DB patients have a medical record number (MRN). In related DB patients have a date of labs and a value of the lab on that date.

MRN DATE SODIUM

11943958 02/22/2010 139

11943958 07/20/2010 137

11943958 09/11/2010 133

11000000 02/22/2010 140

11000000 07/20/2010 135

11000000 09/11/2010 139

I NEED

MRN 02/22/2010 07/20/2010 09/11/2010

11943958 139 137 133

11000000 140 135 139

The dates of lab collection are fixed as this is part of data collection for a study

[Wim Decorte]

probably the easiest way is to loop through the related records and build the report in variables. Then dump the output of the variables in a scratch table that has the field structure suitable for export and export from there.

"dumping the output" means looping through your collected variables and creating records and setting fields in your scratch/temp table.