SwissClinicalTrialOrganisation / secuTrialR

Handling of data from the clinical data management system secuTrial
https://swissclinicaltrialorganisation.github.io/secuTrialR/
Other
8 stars 12 forks source link

Add new columns with `formname` and `fglabel` to repetition tables #236

Open DrEspresso opened 3 years ago

DrEspresso commented 3 years ago

Problem

A single repetition group can be added to multiple forms, and even to multiple questions within the same form in secuTrial. In the export, the repetition tables emnp... contain a column docid which identifies the parent document, and a column fgid which links to the table questions. For an user without background knowledge of secuTrial, it is difficult to resolve this link, as they often ignore this type of metadata columns.

Describe the solution you'd like I suggest a new feature, where the columns formname and fglabel of the table questions are automatically joined to each repetition table emnp... by fgid as part of read_secuTrial()