Differences

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

--- wiki:autolit:extraction:export [2023/06/07 00:05]
jthurnham [Accessing the CER Export page]
+++ wiki:autolit:extraction:export [2023/12/12 13:25] (current)
kevinkallmes [4. Add Columns]
@@ 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 =====

Nested Knowledge

User Tools

Site Tools

Differences

Page Tools