This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
wiki:autolit:extraction:export [2023/10/02 15:31] jthurnham |
wiki:autolit:extraction:export [2024/09/23 14:07] (current) jthurnham [4. Add Columns] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Exporting Custom Tables and CER Materials ====== | ====== Exporting Custom Tables and CER Materials ====== | ||
- | If you'd like to export contents from your nest, you can use the Export page or [[wiki: | + | If you'd like to export contents from your nest, you can use the Export page or [[:wiki: |
- | <WRAP center round important 60%> | ||
- | NOTE: Most Export functions have **moved to Inspector**. | ||
- | |||
- | Specifically, | ||
- | </ | ||
**Use this Export page for:** | **Use this Export page for:** | ||
- | * Custom Table Export and | ||
- | * CER Builder. | ||
- | **Use [[wiki: | + | * Custom Table Export (one-time exports) |
+ | * CER Builder | ||
+ | |||
+ | **Use [[:wiki: | ||
* Study metadata (CSV or RIS Files) | * Study metadata (CSV or RIS Files) | ||
* Screening decisions | * Screening decisions | ||
Line 20: | Line 16: | ||
* Critical Appraisal | * Critical Appraisal | ||
* All Full Text PDFs | * All Full Text PDFs | ||
+ | |||
+ | **Additionally, | ||
Line 36: | Line 34: | ||
Under Synthesis, click " | Under Synthesis, click " | ||
- | {{ :undefined:customcer.png?nolink |}} | + | {{ :undefined:screenshot_2024-09-23_at_14.34.36.png?nolink |}} |
It should already be opened to Custom Tables; if you navigate away, click the " | It should already be opened to Custom Tables; if you navigate away, click the " | ||
Line 43: | Line 41: | ||
==== 2. Choose Type of Table ==== | ==== 2. Choose Type of Table ==== | ||
- | Click on the drop-down menu under "Table of" in order to choose whether you would like a table showing elements from the study as a whole, the various study arms in each study (placebo, intervention groups, etc.), | + | Click on the drop-down menu under "Table of" in order to choose whether you would like a table showing elements from the study as a whole, the various study arms in each study (placebo, intervention groups, etc.), across all interventions |
{{ : | {{ : | ||
- | **Note** that if you want to be able to export/ | + | Note: A Study Arm or Interventions table can only be generated if they were assigned during Meta-Analytical Extraction. Otherwise, selecting either |
=== Table of Studies === | === Table of Studies === | ||
- | Export a Table of Studies if you want one row per study, and **only if you do not plan to export Data Elements**. This is because the only Data Element that is scoped to the Study (rather than Study Arm) is total Study Size. | + | Export a Table of Studies if you want one row per study, and eextracted data from Tagging as individual columns |
- | To choose a Table of Studies, select " | + | To choose a Table of Studies, select " |
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2024-09-23_at_14.45.04.png?nolink |}} |
=== Table of Study Arms === | === Table of Study Arms === | ||
- | Export a Table of Study Arms if you want each arm in each study to have its own row. This is the most similar table type to the Export All Data option below. | + | Export a Table of Study Arms if you have completed MA Extraction and want each arm in each study to have its own row. This is the most similar table type to the Export All Data option below. |
+ | |||
+ | This is the most common export type for completing statistical analysis, since it is the **only table type that can list the exact data elements from the underlying studies.** It will create a table where each row is an arm (so a study, as shown by the boxes, may be split into multiple rows in blue below), and can have bibliographic, | ||
- | This is the most common export type for completing statistical analysis, since it is the **only table type that can list the exact data elements from the underlying studies.** It will create a table where each row is an arm (so a study, as shown by the boxes, may be split into multiple rows), and can have bibliographic, | + | {{ :undefined:screenshot_2024-09-23_at_14.47.15.png?nolink |}} |
=== Table of Interventions === | === Table of Interventions === | ||
- | Export a Table of Interventions if you want to summarize all data at the level of Interventions. This is the most similar table type to the initial Summary view of Quantitative Synthesis. | + | Export a Table of Interventions if you have completed MA Extraction and want to summarize all data at the level of Interventions. This is the most similar table type to the initial Summary view of Quantitative Synthesis. |
- | This table type will have each Intervention in a row, and the only options for rows will be summaries of the Data Elements for each Intervention: | + | This table type will have each Intervention in a row (red) , and the only options for rows will be summaries of the Data Elements for each Intervention |
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2024-09-23_at_14.49.39.png?nolink |}} |
=== Table of Tags === | === Table of Tags === | ||
Line 82: | Line 83: | ||
* The Recursive Frequency of that tag, representing how commonly that tag OR any of its children were used | * The Recursive Frequency of that tag, representing how commonly that tag OR any of its children were used | ||
- | {{:wiki:autolit: | + | {{ :undefined:screenshot_2024-09-23_at_14.51.16.png?nolink |}} |
Line 89: | Line 90: | ||
If you want to export only the data from a subset of the studies in the nest, use the " | If you want to export only the data from a subset of the studies in the nest, use the " | ||
- | * In **Tables of Studies**, you can filter to studies that have a Tag at or below a certain level. | + | * In **Tables of Studies**, you can filter to studies that have a Tag at or below a certain level, studies in a specific related report family, or studies that are primary or secondary. |
- | * In **Tables of Study Arms**, you can filter to study arms that have a certain Intervention, | + | * In **Tables of Study Arms**, you can filter to study arms that have a Tag at or below a certain level, related report family or type, has certain Intervention, |
* In **Tables of Interventions**, | * In **Tables of Interventions**, | ||
* In **Tables of Tags**, you can filter to studies that have a Tag at or below a certain level. | * In **Tables of Tags**, you can filter to studies that have a Tag at or below a certain level. | ||
Line 101: | Line 102: | ||
* **Bibliographic Data: | * **Bibliographic Data: | ||
- | * To add all citation information in one cell, select " | + | |
- | * **Tag: | + | |
+ | |||
+ | * **Meta-Analytical Extraction: | ||
+ | * **Arm Data:** includes Intervention and Arm Size (MA Extraction only) | ||
+ | * **Tag: | ||
* **Intervention: | * **Intervention: | ||
- | * **Study/Arm Size: | + | * **Study/Arm Size: |
- | * **Data Element: | + | * **Data Element: |
- | {{:wiki: | + | * **Tag MetaData:** Add the name, description, |
+ | * **Tag Statistics: | ||
- | {{ https:// | + | {{ :undefined: |
=== Including Tag Tables === | === Including Tag Tables === | ||
Line 114: | Line 120: | ||
If you have configured and extracted data in tag tables, you can add individual tags to your custom table or add all table contents. To do so, under the columns dropdown select "Exact Tag" and you will see both options. Tags with an associated table will have a table icon next to them allowing you to pick and choose: | If you have configured and extracted data in tag tables, you can add individual tags to your custom table or add all table contents. To do so, under the columns dropdown select "Exact Tag" and you will see both options. Tags with an associated table will have a table icon next to them allowing you to pick and choose: | ||
- | {{ : | + | {{ : |
Or select "All Table Contents" | Or select "All Table Contents" | ||
- | {{ : | + | {{ : |
When multiple tables are added, NK attempts to join columns that share similar names to reduce duplicate columns. In the below example, both the Age and Sex tables had a column for " | When multiple tables are added, NK attempts to join columns that share similar names to reduce duplicate columns. In the below example, both the Age and Sex tables had a column for " | ||
- | {{ : | + | {{ : |
If this is incorrect, you can manually unjoin them by clicking the icon between tag tables listed (circled in red below) and clicking " | If this is incorrect, you can manually unjoin them by clicking the icon between tag tables listed (circled in red below) and clicking " | ||
- | {{ : | + | {{ : |
==== 5. Reorder Columns ==== | ==== 5. Reorder Columns ==== | ||
Line 138: | Line 145: | ||
{{ : | {{ : | ||
+ | ==== Advanced Settings ==== | ||
+ | |||
+ | Once you start customizing your table, you can also toggle with the advanced setting. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | By default, when you add multiple tag columns to your table that are organized under separate root tags in the hierarchy, they will be exported into separate sheets within your workbook. This can be helpful to organize large datasets. This can be turned off by unchecking the box, and all columns will be encompassed in a single sheet. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | === Multiple Tag Columns === | ||
+ | |||
+ | See below for an example of tags organized under separate root tags. Specifically, | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | If you were to add both these tags as columns in your custom table... | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ...the export will separate their data into separate sheets within your workbook to mimic the structure of your hierarchy. Note: adding additional tag columns from under the same root tag will be encompassed in this same sheet and the initial bibliographic columns are maintained in each sheet. | ||
+ | |||
+ | Sheet 1: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Sheet 2: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | However, unchecking advanced settings ensures all data is encompassed within one sheet in your workbook: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | **When your table is customized with the settings of your choice, click Download.** | ||
===== CER-specific Exports ===== | ===== CER-specific Exports ===== | ||
Line 162: | Line 204: | ||
=== 2. Screening Export === | === 2. Screening Export === | ||
- | To export a record of all studies Screened in your nest, with full citation information and links to full texts, as well as the Screening status and (if excluded) the Exclusion Reason, select " | + | To export a record of all studies Screened in your nest, with full citation information and links to full texts, as well as the Screening status and (if excluded) the Exclusion Reason, select " |
- | + | ||
- | {{: | + | |
- | Then, choose whether to export as a .docx or a .csv, and select " | + | {{ : |
- | {{:wiki: | + | Then, choose whether to export as a .docx or a .csv, and select " |
+ | {{ : | ||
===== Export All Data or Export RIS Files ===== | ===== Export All Data or Export RIS Files ===== |