Designer Cloud on AWSTrifacta ApplicationWrangle LanguageLanguage AppendicesLanguage AppendicesThis section contains additional topics on Wrangle.TransformsCase TransformComment TransformCountpattern TransformDeduplicate TransformDelete TransformDerive TransformDrop TransformExtract TransformExtractkv TransformExtractlist TransformFilter TransformFlatten TransformHeader TransformKeep TransformMerge TransformMove TransformNest TransformPivot TransformRename TransformReplace TransformSet TransformSettype TransformSort TransformSplit TransformSplitrows TransformUnnest TransformUnpivot TransformValuestocols TransformWindow TransformTransformation ExamplesEXAMPLE - ARRAYINDEXOF and ARRAYRIGHTINDEXOF FunctionsEXAMPLE - ARRAYLEN and ARRAYELEMENTAT FunctionsEXAMPLE - ARRAYSLICE and ARRAYMERGEELEMENTS FunctionsEXAMPLE - ARRAYSTOMAP FunctionEXAMPLE - Base64 Encoding FunctionsEXAMPLE - Case FunctionsEXAMPLE - Comparison Functions1EXAMPLE - Comparison Functions2EXAMPLE - Comparison Functions EqualEXAMPLE - Conditional Calculations FunctionsEXAMPLE - COUNT FunctionsEXAMPLE - COUNTIF FunctionsEXAMPLE - Countpattern TransformEXAMPLE - DATE and TIME FunctionsEXAMPLE - Date Difference FunctionsEXAMPLE - DATEDIF FunctionEXAMPLE - Date FunctionsEXAMPLE - Date Functions - Min Max and ModeEXAMPLE - DATEIF FunctionsEXAMPLE - Day of FunctionsEXAMPLE - DEGREES and RADIANS FunctionsEXAMPLE - Delete and Keep TransformsEXAMPLE - Domain FunctionsEXAMPLE - Double Metaphone FunctionsEXAMPLE - Exponentional FunctionsEXAMPLE - Extractkv and Unnest TransformsEXAMPLE - Extractlist TransformEXAMPLE - Extract ValuesEXAMPLE - Flatten an ArrayEXAMPLE - Flatten and Unnest TransformsEXAMPLE - Flatten and Valuestocols TransformsEXAMPLE - IF Data Type Validation FunctionsEXAMPLE - IPTOINT FunctionEXAMPLE - KTHLARGESTDATE FunctionsEXAMPLE - KTHLARGEST FunctionEXAMPLE - KTHLARGESTIF FunctionEXAMPLE - LIST and UNIQUE FunctionEXAMPLE - LISTIF FunctionsEXAMPLE - LIST Math FunctionsEXAMPLE - Logical FunctionsEXAMPLE - Nest and Unnest JSON RecordsEXAMPLE - Nest Columns into ArraysEXAMPLE - Nest Columns into ObjectsEXAMPLE - Nested FunctionsEXAMPLE - Nest JSON RecordsEXAMPLE - NEXT FunctionEXAMPLE - NOW and TODAY FunctionsEXAMPLE - Numeric FunctionsEXAMPLE - Percentile FunctionsEXAMPLE - POW and SQRT FunctionsEXAMPLE - PREV FunctionEXAMPLE - Quote ParameterEXAMPLE - RANDBETWEEN and PI FunctionsEXAMPLE - RANK FunctionsEXAMPLE - Replacement TransformsEXAMPLE - Rolling Date FunctionsEXAMPLE - Rolling FunctionsEXAMPLE - Rolling Functions 2EXAMPLE - ROLLINGKTHLARGEST FunctionsEXAMPLE - Rounding FunctionsEXAMPLE - Change data type transformationEXAMPLE - Rename columns with rowsEXAMPLE - Splitting with Different Delimiter TypesEXAMPLE - STARTSWITH and ENDSWITH FunctionsEXAMPLE - Statistical FunctionsEXAMPLE - Statistical Functions Sample MethodEXAMPLE - String Cleanup FunctionsEXAMPLE - String Comparison FunctionsEXAMPLE - SUMIF and COUNTDISTINCTIF FunctionsEXAMPLE - SUMIF FunctionEXAMPLE - Time Zone Conversion FunctionsEXAMPLE - Trigonometry Arc FunctionsEXAMPLE - Trigonometry FunctionsEXAMPLE - Trigonometry Hyperbolic Arc FunctionsEXAMPLE - Trigonometry Hyperbolic FunctionsEXAMPLE - Two-Column Statistical FunctionsEXAMPLE - Type FunctionsEXAMPLE - Type Parsing FunctionsEXAMPLE - UNICODE FunctionEXAMPLE - Unixtime FunctionsEXAMPLE - Unnest an ArrayEXAMPLE - Unnest JSON RecordsEXAMPLE - Extract Keys From ObjectsEXAMPLE - Extract Object ValuesEXAMPLE - Filtering Strings into Objects