Go to start of metadata
Skip to end of metadata
Go to start of metadata
- Created by docuser1, last modified on Aug 16, 2022
Explore documentation for Designer Cloud Powered by Trifacta® Enterprise Edition.
Click to display sub-topics
Topics:
- Product Overview
- Release Notes
- Install
- Install Planning
- Install Overview
- Install Software
- Install Databases
- Start and Stop the Platform
- Login
- Install Configuration
- Install Reference
- Install from AWS Marketplace
- Install from AWS Marketplace with EMR
- Install from Azure Marketplace
- Upgrade for AWS Marketplace
- Upgrade for AWS Marketplace with EMR
- Upgrade for Azure Marketplace
- Configure
- Platform Configuration Methods
- Required Platform Configuration
- Configure for High Availability
- Configure for Hadoop
- Configure for AWS
- Configure for Azure
- Configure Security
- Configure SSO for AD-LDAP
- Configure SSO for SAML
- Configuring Platform Users
- Configure Desktops
- Configure Features
- Configure Services
- Miscellaneous Configuration
- Tune Application Performance
- Connect
- Connection Types
- Create Oracle Connections
- Create PostgreSQL Connections
- Create MySQL Connections
- Create SQL Server Connections
- Create Redshift Connections
- S3 Connections
- Create AWS Glue Connections
- Create Snowflake Connections
- Create Azure SQL Database Connections
- Create SQL DW Connections
- Create Databricks Tables Connections
- Create SFTP Connections
- Enable Teradata Connections
- MongoDB Connections
- Create Tableau Server Connections
- Create Salesforce Connections
- Create SharePoint Connections
- Create DB2 Connections
- Configure Connectivity
- Connection Types
- Admin
- Admin Tasks
- Configure Running Environments
- Verify Operations
- Configure Password Criteria
- Create User Account
- Create Admin Account
- Required AWS Account Permissions
- Insert Trust Relationship in AWS IAM Role
- Invite Workspace Users
- Manage Users under SSO
- Create Role
- Manage Schedules
- Operations Tasks
- Access Management Tasks
- User Admin Tasks
- Application Management Tasks
- System Services and Logs
- Backup and Recovery
- Admin Reference
- Admin Tasks
- Workflow Basics
- Common Tasks
- Import Tasks
- Discovery Tasks
- Validation Tasks
- Structuring Tasks
- Cleanse Tasks
- Rename Columns
- Sanitize Column Names
- Change Column Data Type
- Copy and Paste Columns
- Create Column by Example
- Remove Data
- Deduplicate Data
- Compare Values
- Replace Cell Values
- Replace Values Using Patterns
- Replace Groups of Values
- Normalize Numeric Values
- Standardize Using Patterns
- Modify String Values
- Manage String Lengths
- Extract Values
- Format Dates
- Apply Conditional Transformations
- Prepare Data for Machine Processing
- Enrichment Tasks
- Publishing Tasks
- Project Management Tasks
- Take a Snapshot
- Track Data Changes
- Add Comments to Your Recipe
- Create Custom Data Types
- Create Target
- Optimize Job Processing
- Diagnose Failed Jobs
- Schedule a Job
- Create Branching Outputs
- Build Sequence of Datasets
- Fix Dependency Issues
- Manage Flows with Folders
- Share a Flow
- Export Flow
- Import Flow
- Create or Replace Macro
- Apply a Macro
- Export Macro
- Import Macro
- Create Flow Webhook Task
- Create Flow Parameter
- Create a Plan
- Import Plan
- Export Plan
- Share a Plan
- Flag for Review
- User Management Tasks
- Concepts
- Feature Overviews
- Overview of Predictive Transformation
- Overview of Standardization
- Overview of Cluster Clean
- Overview of Visual Profiling
- Overview of Sampling
- Overview of TBE
- Overview of Data Quality
- Overview of Sharing
- Overview of Job Monitoring
- Overview of Automator
- Overview of Parameterization
- Overview of Authorization
- Overview of Operationalization
- Overview of Macros
- Overview of Deployment Manager
- Overview of Pattern Matching
- Overview of RapidTarget
- Recipe Development
- Using Connections
- Feature Overviews
- Wrangle Language
- Aggregate Functions
- ANY Function
- ANYIF Function
- APPROXIMATEMEDIAN Function
- APPROXIMATEPERCENTILE Function
- APPROXIMATEQUARTILE Function
- AVERAGE Function
- AVERAGEIF Function
- CORREL Function
- COUNTA Function
- COUNTAIF Function
- COUNTDISTINCT Function
- COUNTDISTINCTIF Function
- COUNT Function
- COUNTIF Function
- COVAR Function
- COVARSAMP Function
- KTHLARGEST Function
- KTHLARGESTIF Function
- KTHLARGESTUNIQUE Function
- KTHLARGESTUNIQUEIF Function
- LIST Function
- LISTIF Function
- MAX Function
- MAXIF Function
- MEDIAN Function
- MIN Function
- MINIF Function
- MODE Function
- MODEIF Function
- PERCENTILE Function
- QUARTILE Function
- STDEV Function
- STDEVIF Function
- STDEVSAMP Function
- STDEVSAMPIF Function
- SUM Function
- SUMIF Function
- UNIQUE Function
- VAR Function
- VARIF Function
- VARSAMP Function
- VARSAMPIF Function
- Logical Functions
- Comparison Functions
- Math Functions
- Trigonometry Functions
- Date Functions
- DATE Function
- TIME Function
- DATETIME Function
- DATEADD Function
- DATEDIF Function
- DATEFORMAT Function
- UNIXTIMEFORMAT Function
- MONTH Function
- MONTHNAME Function
- EOMONTH Function
- YEAR Function
- DAY Function
- WEEKNUM Function
- WEEKDAY Function
- WEEKDAYNAME Function
- HOUR Function
- MINUTE Function
- SECOND Function
- UNIXTIME Function
- NOW Function
- TODAY Function
- PARSEDATE Function
- NETWORKDAYS Function
- NETWORKDAYSINTL Function
- MINDATE Function
- MAXDATE Function
- MODEDATE Function
- WORKDAY Function
- WORKDAYINTL Function
- CONVERTFROMUTC Function
- CONVERTTOUTC Function
- CONVERTTIMEZONE Function
- MINDATEIF Function
- MAXDATEIF Function
- MODEDATEIF Function
- KTHLARGESTDATE Function
- KTHLARGESTUNIQUEDATE Function
- KTHLARGESTUNIQUEDATEIF Function
- KTHLARGESTDATEIF Function
- SERIALNUMBER Function
- String Functions
- CHAR Function
- UNICODE Function
- UPPER Function
- LOWER Function
- PROPER Function
- TRIM Function
- REMOVEWHITESPACE Function
- REMOVESYMBOLS Function
- LEN Function
- FIND Function
- RIGHTFIND Function
- SUBSTRING Function
- SUBSTITUTE Function
- LEFT Function
- RIGHT Function
- PAD Function
- MERGE Function
- STARTSWITH Function
- ENDSWITH Function
- REPEAT Function
- EXACT Function
- STRINGGREATERTHAN Function
- STRINGGREATERTHANEQUAL Function
- STRINGLESSTHAN Function
- STRINGLESSTHANEQUAL Function
- DOUBLEMETAPHONE Function
- DOUBLEMETAPHONEEQUALS Function
- TRANSLITERATE Function
- TRIMQUOTES Function
- BASE64ENCODE Function
- BASE64DECODE Function
- Nested Functions
- ARRAYCONCAT Function
- ARRAYCROSS Function
- ARRAYELEMENTAT Function
- ARRAYINDEXOF Function
- ARRAYINTERSECT Function
- ARRAYLEN Function
- ARRAYMERGEELEMENTS Function
- ARRAYRIGHTINDEXOF Function
- ARRAYSLICE Function
- ARRAYSORT Function
- ARRAYSTOMAP Function
- ARRAYUNIQUE Function
- ARRAYZIP Function
- FILTEROBJECT Function
- KEYS Function
- LISTAVERAGE Function
- LISTMAX Function
- LISTMIN Function
- LISTMODE Function
- LISTSTDEV Function
- LISTSUM Function
- LISTVAR Function
- Type Functions
- Window Functions
- PREV Function
- NEXT Function
- FILL Function
- RANK Function
- DENSERANK Function
- ROLLINGAVERAGE Function
- ROLLINGMODE Function
- ROLLINGMAX Function
- ROLLINGMIN Function
- ROLLINGMODEDATE Function
- ROLLINGMAXDATE Function
- ROLLINGMINDATE Function
- ROLLINGSUM Function
- ROLLINGSTDEV Function
- ROLLINGSTDEVSAMP Function
- ROLLINGVAR Function
- ROLLINGVARSAMP Function
- ROLLINGCOUNTA Function
- ROLLINGKTHLARGEST Function
- ROLLINGKTHLARGESTUNIQUE Function
- ROLLINGLIST Function
- ROWNUMBER Function
- SESSION Function
- Other Functions
- Other Language Topics
- Language Index
- Language Appendices
- 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
- Transforms
- Aggregate Functions
- Reference
- UI Reference
- Home Page
- Flows Page
- Create Flow Page
- Flow View Page
- View for Imported Datasets
- View for Dataset with Parameters
- View for Recipes
- View for Reference Datasets
- View for Unstructured Datasets
- View for Outputs
- Share Flow Dialog
- Change Dataset Dialog
- Add Schedule Dialog
- Manage Flow Notifications Dialog
- Manage Parameters Dialog
- Flow Search Panel
- Flow Optimization Settings Dialog
- Plans Page
- Library Page
- Jobs Page
- Transformer Page
- Preferences Page
- Schedules Page
- UI Index
- Supported Data Types
- String Data Type
- Integer Data Type
- Decimal Data Type
- Boolean Data Type
- Social Security Number Data Type
- Phone Number Data Type
- Email Address Data Type
- Credit Card Data Type
- Gender Data Type
- Zip Code Data Type
- State Data Type
- Object Data Type
- Array Data Type
- IP Address Data Type
- URL Data Type
- HTTP Code Data Type
- Datetime Data Type
- Column Statistics Reference
- Type Conversions
- Avro Data Type Conversions
- DB2 Data Type Conversions
- Hive Data Type Conversions
- Oracle Data Type Conversions
- MySQL Data Type Conversions
- Parquet Data Type Conversions
- Postgres Data Type Conversions
- Redshift Data Type Conversions
- Snowflake Data Type Conversions
- AWS Glue Data Type Conversions
- Salesforce Data Type Conversions
- SQL Server Data Type Conversions
- SQL DW Data Type Conversions
- Databricks Tables Data Type Conversions
- Tableau Hyper Data Type Conversions
- Teradata Data Type Conversions
- SharePoint Data Type Conversions
- Transformation Reference
- Plan Metadata References
- Supported Time Zone Values
- cron Schedule Syntax Reference
- Join Types
- Join Metrics
- Supported File Encoding Types
- Sort Order
- Support Bundle Contents
- Locale Settings
- Sample Types
- UI Reference
- Developer
- User-Defined Functions
- Create Custom Data Types Using RegEx
- API Reference
- Manage API Access Tokens
- API Endpoints for Trifacta Wrangler Enterprise
- API Workflows
- API Workflow - Develop a Flow
- API Workflow - Deploy a Flow
- API Workflow - Run Job
- API Workflow - Run Job on Dataset with Parameters
- API Workflow - Run Deployment
- API Workflow - Publish Results
- API Workflow - Swap Datasets
- API Workflow - Manage Outputs
- API Workflow - Manage AWS Configurations
- API Workflow - Run Plan
- API Workflow - Wrangle Output to Python
- API Documentation Versions
- Platform
- Search by Category
- Glossary
- PDF Documentation
- Contact Support
- Legal
- About These Docs
This page has no comments.