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/11 12:27] jthurnham [5. Reorder Columns] |
wiki:autolit:extraction:export [2023/12/12 13:25] (current) kevinkallmes [4. Add Columns] |
||
---|---|---|---|
Line 101: | Line 101: | ||
* **Bibliographic Data: | * **Bibliographic Data: | ||
+ | * 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 " | * To add all citation information in one cell, select " | ||
* **Tag: | * **Tag: | ||
Line 114: | Line 115: | ||
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 140: | ||
{{ : | {{ : | ||
- | **When | + | ==== Advanced Settings ==== |
+ | |||
+ | Once you start customizing 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 | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | === Multiple Tag Columns === | ||
+ | |||
+ | See below for an example | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | If you were to add both these tags as columns in your custom | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ...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 ===== | ||