Alteryx Trifacta Classic Experience Wrangle Language Language Appendices Language Appendices This section contains additional topics on Wrangle. Transforms Case Transform Comment Transform Countpattern Transform Deduplicate Transform Delete Transform Derive Transform Drop Transform Extract Transform Extractkv Transform Extractlist Transform Filter Transform Flatten Transform Header Transform Keep Transform Merge Transform Move Transform Nest Transform Pivot Transform Rename Transform Replace Transform Set Transform Settype Transform Sort Transform Split Transform Splitrows Transform Unnest Transform Unpivot Transform Valuestocols Transform Window Transform Transformation Examples EXAMPLE - ARRAYINDEXOF and ARRAYRIGHTINDEXOF Functions EXAMPLE - ARRAYLEN and ARRAYELEMENTAT Functions EXAMPLE - ARRAYSLICE and ARRAYMERGEELEMENTS Functions EXAMPLE - ARRAYSTOMAP Function EXAMPLE - Base64 Encoding Functions EXAMPLE - Case Functions EXAMPLE - Comparison Functions1 EXAMPLE - Comparison Functions2 EXAMPLE - Comparison Functions Equal EXAMPLE - Conditional Calculations Functions EXAMPLE - COUNT Functions EXAMPLE - COUNTIF Functions EXAMPLE - Countpattern Transform EXAMPLE - DATE and TIME Functions EXAMPLE - Date Difference Functions EXAMPLE - DATEDIF Function EXAMPLE - Date Functions EXAMPLE - Date Functions - Min Max and Mode EXAMPLE - DATEIF Functions EXAMPLE - Day of Functions EXAMPLE - DEGREES and RADIANS Functions EXAMPLE - Delete and Keep Transforms EXAMPLE - Domain Functions EXAMPLE - Double Metaphone Functions EXAMPLE - Exponentional Functions EXAMPLE - Extractkv and Unnest Transforms EXAMPLE - Extractlist Transform EXAMPLE - Extract Values EXAMPLE - Flatten an Array EXAMPLE - Flatten and Unnest Transforms EXAMPLE - Flatten and Valuestocols Transforms EXAMPLE - IF Data Type Validation Functions EXAMPLE - IPTOINT Function EXAMPLE - KTHLARGESTDATE Functions EXAMPLE - KTHLARGEST Function EXAMPLE - KTHLARGESTIF Function EXAMPLE - LIST and UNIQUE Function EXAMPLE - LISTIF Functions EXAMPLE - LIST Math Functions EXAMPLE - Logical Functions EXAMPLE - Nest and Unnest JSON Records EXAMPLE - Nest Columns into Arrays EXAMPLE - Nest Columns into Objects EXAMPLE - Nested Functions EXAMPLE - Nest JSON Records EXAMPLE - NEXT Function EXAMPLE - NOW and TODAY Functions EXAMPLE - Numeric Functions EXAMPLE - Percentile Functions EXAMPLE - POW and SQRT Functions EXAMPLE - PREV Function EXAMPLE - Quote Parameter EXAMPLE - RANDBETWEEN and PI Functions EXAMPLE - RANK Functions EXAMPLE - Replacement Transforms EXAMPLE - Rolling Date Functions EXAMPLE - Rolling Functions EXAMPLE - Rolling Functions 2 EXAMPLE - ROLLINGKTHLARGEST Functions EXAMPLE - Rounding Functions EXAMPLE - Change data type transformation EXAMPLE - Rename columns with rows EXAMPLE - Splitting with Different Delimiter Types EXAMPLE - STARTSWITH and ENDSWITH Functions EXAMPLE - Statistical Functions EXAMPLE - Statistical Functions Sample Method EXAMPLE - String Cleanup Functions EXAMPLE - String Comparison Functions EXAMPLE - SUMIF and COUNTDISTINCTIF Functions EXAMPLE - SUMIF Function EXAMPLE - Time Zone Conversion Functions EXAMPLE - Trigonometry Arc Functions EXAMPLE - Trigonometry Functions EXAMPLE - Trigonometry Hyperbolic Arc Functions EXAMPLE - Trigonometry Hyperbolic Functions EXAMPLE - Two-Column Statistical Functions EXAMPLE - Type Functions EXAMPLE - Type Parsing Functions EXAMPLE - UNICODE Function EXAMPLE - Unixtime Functions EXAMPLE - Unnest an Array EXAMPLE - Unnest JSON Records EXAMPLE - Extract Keys From Objects EXAMPLE - Extract Object Values EXAMPLE - Filtering Strings into Objects