Differences

This shows you the differences between two versions of the page.

--- wiki:autolit:extraction:export [2023/06/07 00:03]
jthurnham [1. Navigate to Export]
+++ wiki:autolit:extraction:export [2023/12/12 13:25] (current)
kevinkallmes [4. Add Columns]
@@ Line 45: / Line 45: @@
 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.), or across all interventions.
-{{:wiki:autolit:extraction:img39.png?nolink&  }}
+{{ :undefined:studyarm.png?nolink |}}
 **Note** that if you want to be able to export/download any extracted data––to create tables for a manuscript, for example––you must select Table of "Study Arm."
@@ Line 101: / Line 101: @@
   * **Bibliographic Data:**  Name, Author, Year, PubMed ID, and/or a Link to the article, among others.
+      * Related Report Families can be identified as one of the pieces of Bibliographic data, with either the custom name or Author, Year of the Primary report.
       * To add all citation information in one cell, select "Citation" from the Attribute drop-down.
   * **Tag:**  The tag names and tag text excerpts at or below a given tag.
@@ Line 109: / Line 110: @@
 {{  https://wiki.nested-knowledge.com//home/ubuntu/nkwiki/dokuwiki/lib/plugins/ckgedit/fckeditor/userfiles/image/wiki/autolit/screenshot2021-10-11at5.11.52pm.png?nolink&  }}
+=== Including Tag Tables ===
+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:
+{{  :undefined:screenshot_2023-10-02_at_16.18.23.png?nolink&  }}
+Or select "All Table Contents" at the top.
+{{  :undefined:screenshot_2023-10-02_at_16.17.12.png?nolink&  }}
+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 "Group" with rows for "Adult" and "Children" so they are joined for the purposes of exporting a custom table as you can see in the preview:
+{{  :undefined:screenshot_2023-10-02_at_16.20.53.png?nolink&  }}
+If this is incorrect, you can manually unjoin them by clicking the icon between tag tables listed (circled in red below) and clicking "X" on the incorrect joining (circled in blue below). Here you can also manually join other column names as appropriate (circled in green).
+{{  :undefined:screenshot_2023-10-02_at_16.28.38.png?nolink&  }}
 ==== 5. Reorder Columns ====
@@ Line 120: / Line 140: @@
 {{ :wiki:autolit:extraction:doi2.png?nolink |}}
+==== Advanced Settings ====
+Once you start customizing your table, you can also toggle with the advanced setting.
+{{ :undefined:screenshot_2023-11-21_at_12.46.38.png?nolink |}}
+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.
+{{ :undefined:screenshot_2023-11-30_at_15.27.38.png?nolink |}}
+=== Multiple Tag Columns ===
+See below for an example of tags organized under separate root tags. Specifically, the tags "Treatments" and "Clinical Effectiveness Evidence" (circled in red) belong to different root tags (circled in orange).
+{{ :undefined:screenshot_2023-11-30_at_14.52.18.png?nolink |}}
+If you were to add both these tags as columns in your custom table...
+{{ :undefined:screenshot_2023-11-30_at_15.04.12.png?nolink |}}
+...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:
+{{ :undefined:screenshot_2023-11-30_at_15.23.28.png?nolink |}}
+Sheet 2:
+{{ :undefined:screenshot_2023-11-30_at_15.24.52.png?nolink |}}
+However, unchecking advanced settings ensures all data is encompassed within one sheet in your workbook:
+{{ :undefined:screenshot_2023-11-30_at_15.32.00.png?nolink |}}
+**When your table is customized with the settings of your choice, click Download.**
 ===== CER-specific Exports =====
@@ Line 128: / Line 183: @@
 To access the CER Export page, select Export from the AutoLit menu, and then in the resulting page, toggle to "CER Builder."
-{{:wiki:autolit:extraction:img41.png?nolink&  }}
+{{ :undefined:certabletype.png?nolink |}}
 ==== Exporting Documents and Data ====

Nested Knowledge

User Tools

Site Tools

Differences

Page Tools