The guide introduces users to CloverDX Wrangler, a versatile data transformation tool designed to streamline the process of extracting, transforming, and loading (ETL) data. CloverDX Wrangler allows users to connect to multiple data sources, clean and transform data, and configure outputs with minimal effort. Its user-friendly interface simplifies complex data tasks, making it accessible to both technical and non-technical users. Wrangler is ideal for automating repeatable processes and ensuring high data quality through validation and error-handling features.

This guide begins with an overview of how CloverDX Wrangler works, offering video tutorials and explanations to help users get started quickly. You’ll learn how to choose data sources, understand job anatomy, and work with various data types. The guide also provides practical advice on using formulas and calculations, handling empty values, modifying values based on conditions, or filtering data.

The Data sources and targets section explains how to create and select data sources and create and configure outputs, ensuring a seamless flow from input to target. Wrangler’s Data Catalog is a powerful feature for searching available data sources published by your company and reviewing connector details, making it easy to integrate new data sources into your workflows.

The Transforming data section guides users through managing jobs on the My Jobs screen and applying transformations using the Steps sidebar. You’ll learn about data quality monitoring, formatting, running jobs, and using the expression language.

The Transformation steps section details specific data manipulation tasks, including text, date, and math transformations, data validation, and anonymization steps. This section also covers conditions for steps and groups, providing users with robust tools to manage complex transformations.