playground:playground
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
playground:playground [2023/11/03 12:11] – add List sheets description craigt | playground:playground [2024/04/11 21:06] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{ transformations: | + | {{ transformations: |
- | ====== | + | ====== |
- | Category: | + | Category: |
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | Import data from a Google Sheets file.\\ | + | This action deterministically calculates hashes for values in one or multiple columns. |
+ | |||
+ | \\ | ||
+ | =====Use Cases===== | ||
+ | Using this action, you can anonymize data without affecting its cardinality so it can be used for merging and aggregation. | ||
+ | |||
\\ | \\ | ||
Line 11: | Line 16: | ||
^ Setting | ^ Setting | ||
- | |Connector< | + | |New column name|Enter a name for the new column containing the hashes. | |
- | |Spreadsheet< | + | |Position| Select where the new column will be positioned in the dataset. Options: |
- | |Import action|Options: | + | |Salt|Check this option and enter a salt value to be used within the creation |
- | + | |Anonymize also empty values|Check this option to generate hashes | |
- | \\ | + | |Columns|Select |
- | ==== 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 | + | |
- | |Load only selected columns|This option allows you to select which columns to import. | + | |
- | < | + | |
- | + | ||
- | \\ | + | |
- | ====List sheets settings==== | + | |
- | **Description: | + | |
- | + | ||
- | \\ | + | |
- | =====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' | + | |
- | + | ||
- | \\ | + | |
- | =====Shortcuts===== | + | |
- | Fast ways to create the action: | + | |
- | * Press the "Add data" menu button. Pick "Fetch from cloud/ | + | |
- | + | ||
- | \\ | + | |
- | =====See also===== | + | |
- | *[[connectors: | + | |
- | + | ||
- | + | ||
- | + | ||
playground/playground.txt · Last modified: 2024/04/11 21:06 by craigt