Version

    1. Wrangler user guide

    The guide introduces users to CloverDX Wrangler, an AI-enabled 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.

    Wrangler allows you to use Clover AI Assistant - a built-in helper that supports you during wrangling by offering smart suggestions and guidance.

    This guide begins with a Tutorial to help users get started quickly. Tutorial will teach you how you can create a simple job using Clover AI Assistant as well as without the Assistant.

    With Clover AI Assistant integrated into the workflow, Wrangler can suggest the next best step or provide explanations directly where you need them, so you don’t lose time searching for solutions.

    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. Clover Assistant can also help by offering suggestions when you are configuring inputs and outputs.

    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. Clover AI Assistant can generate a summary of your job, providing a clear overview of applied transformations and outcomes.

    The Transformation steps section details specific data manipulation tasks, including text, date, and math transformations, data validation, and anonymization steps. Transformations are organized into blocks, which act as the main containers for steps, notes, and groups. This structure helps you keep related transformations together and maintain a clear overview of your workflow. In this section, you can also find more information about conditions for steps and groups which can help you manage more complex transformations.

    Finally, head over to the Frequently Asked Questions page to get answers to common questions related to <id_choosing_data_source, choosing data source for your job>>, working with various data types, using conditions, using formulas, and more…​

    transformation editor screen
    Figure 1. Wrangler transformation editor