playground:playground
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
playground:playground [2023/02/01 18:39] – craigt | playground:playground [2023/11/03 12:11] (current) – add List sheets description craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{ transformations: | + | {{ transformations: |
- | ====== | + | ====== |
- | Category: | + | Category: |
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This action retrieves | + | Import data from a Google Sheets file.\\ |
- | + | ||
- | \\ | + | |
- | =====Use cases===== | + | |
- | Use the various modes of this action to extract information about Catalog items, and manipulate the structure of the Data Catalog. | + | |
- | + | ||
- | Use field items to store and retrieve metadata items about the resource or resource' | + | |
\\ | \\ | ||
- | =====Action settings===== | + | ===== Action settings ===== |
- | ^ Setting | + | |
- | |Retrieve|Select the type of Catalog resource to retrieve. | + | |
- | |Catalog item< | + | |
- | < | + | ^ Setting |
+ | |Connector< | ||
+ | |Spreadsheet< | ||
+ | |Import action|Options: | ||
+ | \\ | ||
+ | ==== Import table settings ==== | ||
+ | ^ Setting | ||
+ | |Sheet or range< | ||
+ | |Skip first lines< | ||
+ | |Columns don't have headers|Check this if your dataset does not include a row with header information| | ||
+ | |Load all columns|This option imports all columns in the sheet.| | ||
+ | |Load only selected columns|This option allows you to select which columns to import. | ||
+ | < | ||
- | ====Results | + | \\ |
- | Note: | + | ====List sheets |
- | ^Setting | + | **Description:** Produce |
- | |Return file path as action' | + | |
- | |Save as< | + | |
+ | \\ | ||
+ | =====Advanced options===== | ||
+ | ^Setting^Description^ | ||
+ | |Do not automatically offset imported range|By default, EasyMorph will align the first column and first row of imported data with column 1 and row 1\\ in the dataset. | ||
+ | |When a floating-point number can' | ||
- | ====Parameters settings===== | + | \\ |
- | //Dataset// Catalog items (EasyMorph native .dset files) can contain parameters that may be set here by selecting | + | =====Shortcuts===== |
+ | Fast ways to create | ||
+ | * Press the "Add data" menu button. Pick "Fetch from cloud/application" | ||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[connectors: | ||
- | \\ | ||
- | =====Remarks===== | ||
- | **Delete directory** - Use this mode //with caution// as any items stored within the selected directory will be deleted as well. Structure your workflow to detect and/or move any items you wish to keep before running this mode. | ||
- | You can **set and remove field items and settings // | ||
- | \\ | ||
- | =====See also===== | ||
- | |||
- | * [[transformations: | ||
playground/playground.txt · Last modified: 2023/11/03 12:11 by craigt