Differences

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

--- wiki:autolit:extraction:export [2023/11/21 12:47]
jthurnham [Advanced Settings]
+++ wiki:autolit:extraction:export [2023/11/30 15:34]
jthurnham [Advanced Settings]
@@ Line 140: / Line 140: @@
 ==== 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.
+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 |}}
-**When you are finished customizing your table, click Download. This will export a .xlsx file of your table.**
+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