AnsweredAssumed Answered

Exporting: Preserving one-to-many relationships

Question asked by bryanade on Feb 15, 2018
Latest reply on Feb 15, 2018 by mike_wallace_rcc

In my database, I have a list of patients. Each time a patient visits, there is a visit record (one patient to many visit records). I'm looking for a way to export this data into a single spreadsheet so that each visit is an additional set of columns, labelled with a suffix like "_1" or "_2" for each subsequent visit. The fact that the interval between visits is unique per patient is not important as I can calculate the time interval for each and create a new variable for each visit to reflect that time interval.

 

Is there a way to automate this, or do I have to set up a table for all "_1"'s and all "_2"'s and then manually export these?

Outcomes