playground:playground
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
playground:playground [2021/09/13 00:03] – craigt | playground:playground [2024/04/11 21:06] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Empty() | + | {{ transformations: |
- | Category: | + | ====== ANONYMIZE/ |
+ | Category: | ||
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This function creates an [[syntax: | + | This action deterministically calculates hashes for values in one or multiple columns. |
\\ | \\ | ||
- | =====Use | + | =====Use |
- | Use //empty()// to insert empty values into cells, or within other functions. | + | Using this action, you can anonymize data without affecting its cardinality so it can be used for merging and aggregation. |
+ | |||
\\ | \\ | ||
- | =====Arguments===== | + | ===== Action settings |
- | This function does not require arguments. | + | |
- | + | ||
- | **Return value type:** Empty value | + | |
- | + | ||
- | \\ | + | |
- | =====Remarks===== | + | |
- | While a value can be tested for an empty value using a "value = empty()" | + | |
- | + | ||
- | \\ | + | |
- | =====Examples===== | + | |
- | + | ||
- | [Content] = empty() | + | |
- | + | ||
- | coalesce(empty(), | + | |
- | + | ||
- | if( [Value] = 10, ' | + | |
- | + | ||
- | + | ||
- | \\ | + | |
- | =====See also===== | + | |
- | * [[syntax: | + | |
- | * [[syntax: | + | |
+ | ^ Setting | ||
+ | |New column name|Enter a name for the new column containing the hashes. | ||
+ | |Position| Select where the new column will be positioned in the dataset. | ||
+ | |Salt|Check this option and enter a salt value to be used within the creation of the hashes. | ||
+ | |Anonymize also empty values|Check this option to generate hashes for empty values.| | ||
+ | |Columns|Select the columns from the list to be anonymized.| | ||
playground/playground.txt · Last modified: 2024/04/11 21:06 by craigt