| Name | Title | Description |
|---|
| scaleminmax | | Scale a column to a specific min max range. See Prepare Data for Machine Processing. |
| onehotencode | | Create a column for each unique value indicating its presence or absence. See Prepare Data for Machine Processing. |
| scalestandardize | | Scale a column to zero mean and unit variance. See Prepare Data for Machine Processing. |
| bincolumn | | Bin values into ranges of equal or custom size. See Prepare Data for Machine Processing. |
| changetype | | Changes the data type of a column [settype]. See See Change Column Data Type. |
| comment | | Adds a comment to your recipe [comment]. See See Add Comments to Your Recipe. |
| conditions | | Returns values based on conditions such as if-then-else or case statements. See See Apply Conditional Transformations. |
| convertpattern | | Finds one or more patterns or text literals and replaces them with specified pattern values. See See Standardize Using Patterns. |
| countmatches | | Counts the number of matches [countpattern]. See See Compute Counts. |
| countmatchesbetween | | Counts the number of matches [countpattern]. See See Compute Counts. |
| deduplicate | | Removes duplicate rows where values in every column are the same. See See Deduplicate Data. |
| derive | | Creates a new column with the result of a formula. |
| drop | | Delete one or more columns. See See Remove Data. |
| extractbetweendelimiters | | Extracts text found between two patterns. See See Extract Values. |
| extractcustom | | Extracts text found between two patterns. Variant: Custom text or pattern. See See Extract Values. |
| extractfirstcharacters | | Extracts text according to its position. Variant: Extract the first n characters. See See Extract Values. |
| extractkv | | Extracts key-value pairs into an Object [extractkv]. See See Extract Values. |
| extractlastcharacters | | Extracts key-value pairs into an Object [extractkv]. Variant: Extract the last n characters. See See Extract Values. |
| extractlist | | Extracts a list into an Array [extractlist]. See See Extract Values. |
| extractrangeofcharacters | | Extracts text according to its position. Variant: Extract the last n characters. See See Extract Values. |
| extractmismatched | | Extracts a list into an Array [extractlist]. Variant: The data type to match against. See See Extract Values. |
| extractnumbers | | Extracts a list into an Array [extractlist]. Variant: Extract numbers from a text. See See Extract Values. |
| extractquerystrings | | Extracts a list into an Array [extractlist]. Variant: Extract fields from an URL query string. See See Extract Values. |
| filtercontains | | Filter rows that satisfy a condition. Variant: Filter rows that contain a specified value or pattern. See See Filter Data. |
| filtercustom | | Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. See See Filter Data. |
| filterendswith | | Filter rows that satisfy a condition. Variant: Filter rows that ends with a specified value or pattern. See See Filter Data. |
| filterexactly | | Filter rows that satisfy a condition. Variant: Filter rows that match exactly a specified value. See See Filter Data. |
| filternot | | Filters rows that do not satisfy a condition. See See Filter Data. |
| filterfromtop | | Filter rows by their position. Variant: Filter rows from the top. See See Filter Data. |
| filtergreaterthan | | Filter rows that satisfy a condition. Variant: Filter rows with values greater than (or equal to) a specified value. See See Filter Data. |
| filterinterval | | Filter rows by their position. Variant: . Variant: The size of the interval to filter rows at. See See Filter Data. |
| filterlessthan | | Filter rows that satisfy a condition. Variant: Filter rows with values less than (or equal to) a specified value. See See Filter Data. |
| filtermissing | | Filter rows that satisfy a condition. Variant: Filter rows with missing values. See See Remove Data. |
| filtermismatched | | Filter rows that satisfy a condition. Variant: Filter rows with mismatched values. See See Filter Data. |
| filteroneof | | Filter rows that satisfy a condition. Variant: Filter rows that match any of the specified values. See See Filter Data. |
| filterrange | | Filter rows by their position. Variant: Filter rows within a range. See See Filter Data. |
| filterstartswith | | Filter rows that satisfy a condition. Variant: Filter rows that starts with a specified value or pattern. See See Filter Data. |
| flatten | | Converts each element in an Array into a new row. See See Working with Arrays. |
| groupby | | Group data and perform aggregated calculations on it. See See Create Aggregations. |
| join | | Adds additional columns from other data sources [join]. See See Join Window. |
| locktype | | Lock column to current type. |
| lowercase | Lowercase text | Format text in columns. Variant: Convert text in column to lowercase. See See Modify String Values. |
| leftpad | | Format text in columns. Variant: Add the necessary number of characters to each value to make them of the same length. See See Modify String Values. |
| merge | | Concatenates the values from two or more columns into a new column [merge]. See See Add Two Columns. |
| move | | Moves one or more columns before or after another column [move]. See Move Columns. |
| nest | | Converts columns into an Object or Array [nest]. See See Working with Arrays. |
| pivot | | Creates a new column for each unique value in a column [pivot]. See See Pivot Data. |
| prefix | Prefix text | Format text in columns. Variant: Specify a prefix to be added at the beginning of each selected column name. See See Modify String Values. |
| propercase | Propercase text | Format text in columns. Variant: Convert text in column to ProperCase. See See Modify String Values. |
| removesymbols | Remove symbols in text | Format text in columns. Variant: Remove all non-alphanumerical characters from the text. See See Remove Data. |
| removewhitespace | Remove whitespace in text | Format text in columns. Variant: Remove all whitespace found in the text. See See Remove Data. |
| removeaccents | Remove accents in text | Remove accent marks from text. See See Modify String Values. |
| rename | | Renames one or more columns [rename]. See See Rename Columns. |
| renamepattern | | Renames one or more columns [rename]. See See Rename Columns. |
| renameprefix | | Renames one or more columns [rename]. See See Rename Columns. |
| renameheader | | Renames one or more columns [rename]. See See Rename Columns. |
| renamesuffix | | Renames one or more columns [rename]. See See Rename Columns. |
| renameupper | | Renames one or more columns [rename]. See Rename Columns. |
| renamelower | | Renames one or more columns [rename]. See Rename Columns. |
| renamekeepleft | | Renames one or more columns [rename]. See Rename Columns. |
| renamekeepright | | Renames one or more columns [rename]. See Rename Columns. |
| renamesanitize | | Renames one or more columns [rename]. See See Rename Columns. |
| replacecell | | Renames one or more columns [rename]. See See Rename Columns. |
| replacepattern | Replace text or pattern | Replace text matching a pattern. See Rename ColumnsSee Replace Cell Values. |
| replacebetweenpatterns | | Replace text between delimiters. Variant: Replace text between delimiters. See Rename ColumnsSee Replace Cell Values. |
| replacebetweenpositions | | Replace text between delimiters. Variant: Replaces text based on position. See Rename ColumnsSee Replace Cell Values. |
| replacemismatched | | Replace mismatched values. See Rename ColumnsSee Replace Cell Values. |
| replacemissing | | Replace missing values. See See Replace Cell Values. |
| select | | Create a new table of columns selected Selectd from your current dataset. See Replace Cell ValuesSelect. |
| set | | Sets the values of one or more columns to the result of a formula [set]. |
| sort | | Sorts the rows based on the values in one or more columns. See Sort Order. |
| splitondelimiter | Split on text or pattern | Split by delimiter. Variant: Text or pattern. See See Split Column. |
| splitbetweendelimiters | | Split by delimiter. Variant: Between two delimiters. See See Split Column. |
| splitmultipledelimiters | | Split by delimiter. Variant: By multiple delimiters. See See Split Column. |
| splitpositions | | Split by character position. Variant: By positions. See See Split Column. |
| splitevery | | Split by character position. Variant: At regular interval. See See Split Column. |
| splitbetweenpositions | | Split by character position. Variant: Between two positions. See See Split Column. |
| splitrows | | Splits raw data into rows [splitrows]. See See Split Column. |
| suffix | Suffix text | Format text in columns. Variant: Specify a suffix to be added to the end of each selected column name. See See Modify String Values. |
| trimwhitespace | | Format text in columns. Variant: Remove all whitespaces found at the beginning and end of the text. See See Modify String Values. |
| trimquotes | | Format text in columns. Variant: Remove quotes found at the beginning and end of the text. See See Modify String Values. |
| udf | | Creates a new column with the result of an external function. | D s ed |
|---|
| not | true |
|---|
| editions | awspr,awsst,gdp,gdpst,gdppr,ss,sspee |
|---|
|
| Info |
|---|
NOTE: This transformation requires additional configuration. |
|
| uppercase | Uppercase text | Format text in columns. Variant: Convert text in column to UPPERCASE. See See Modify String Values. |
| dateformat | | Change format for Datetime columns. See See Format Dates. |
| union | | Adds additional rows from other data source [union]. See See Union Page. |
| standardize | | Single-column standardization for standardizing column values. See See Standardize Page. |
| columnbyexample | | Create a new column by providing example values. See See Create Column by Example. |
| unlocktype | | Unlock column type. |
| unnest | | Extracts elements from an Object or Array into columns. See See Working with Arrays. |
| unpivot | | Turns columns into rows. Produces a key column with unnested values. See See Pivot Data. |
| valuestocols | | Creates a new column for each unique value in a column [valuestocols]. See See Pivot Data. |
| window | | Performs row-based calculations across multiple ordered rows [window]. See See Window Functions. |
| sourcerownumber | | Generate a new column containing the row number for each row from the source, if available. See See Source Metadata References. |
| filepath | | Generate a new column containing the path to the source file, if available. See See Source Metadata References. |
