User Tools

Site Tools


playground:playground

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
playground:playground [2021/09/13 00:03] craigtplayground:playground [2024/04/11 21:06] (current) craigt
Line 1: Line 1:
-===== Empty() ===== +{{ transformations:AnonymizeHashAction.png}} 
-Category:  Special function+====== ANONYMIZE/HASH ====== 
 +Category: Transform / Advanced\\
  
 \\  \\ 
 =====Description===== =====Description=====
-This function creates an [[syntax:types#empty_values|empty value]].+This action deterministically calculates hashes for values in one or multiple columns.
  
 \\  \\ 
-=====Use cases===== +=====Use Cases===== 
-Use //empty()// to insert empty values into cellsor within other functions.+Using this actionyou 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()" expression, the [[syntax:functions:isempty|IsEmpty]] function can also be used.  The two approaches are equivalent. +
- +
-\\  +
-=====Examples===== +
- +
-  [Content] = empty()  //Returns TRUE if [Content] contains an empty value, otherwise, FALSE. +
- +
-  coalesce(empty(), 'ABC', '' //Using empty() as an argument within a function. +
- +
-  if( [Value] = 10, 'Ten', empty() )  //Using empty() to set an empty value in an If statement. +
- +
- +
-\\  +
-=====See also===== +
-  * [[syntax:functions:isempty|IsEmpty(expression)]] +
-  * [[syntax:types|The EasyMorph Type system]]+
  
 +^ Setting  ^ Description ^
 +|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.  Options:  //Rightmost//, //Leftmost//, or\\ //After column// (and select an existing column).  |
 +|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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki