CloverDX Wrangler | CloverDX 6.0.0 Documentation

CloverDX Wrangler

User’s Guide

This User’s Guide refers to CloverDX Wrangler 6.0.0 release.

Do not copy or distribute without express permission of CloverDX a.s.

http://www.cloverdx.com

Feedback welcome:

If you have any comments or suggestions for this documentation, please send them by email to support@cloverdx.com.

Consider How to speed up communication with CloverCARE support before contacting the support.

1. Getting started

How Wrangler works (video)

Quick tutorial (video)

Source: Choosing data for your job

Combining multiple data sources

Lookup configuration
Lookup hints

Job anatomy: Understanding steps and repeatability

Moving between steps

What to consider before adding a column

Column data types

Formulas and calculations

Comparing values
Calculations and functions

Modify values based on a condition

if function
Ternary operator

Working with strings (text)

Working with decimals (including currency)

Working with dates

Errors in your data

No data or some missing?

No value: Working with null and empty values

Replacing empty value with a default value

Filtering data

Getting results from your job

Target file configuration

2. Data Catalog

Explorer view
Searching in the Data Catalog
Connector details
My sources view
Adding connector to My sources

3. Reading data in Wrangler

CSV data source

Configuring CSV data source
Where are my CSV files?
Limitations of the CSV data source

Library data sources

Adding new connectors
Using library connectors

4. Writing data in Wrangler

Downloading and viewing output files

CSV data target

CSV data target configuration
CSV data target limitations

Excel data target

Excel data target configuration
Formatting of Excel files
Excel data target limitations

5. Transforming data

Creating your job

Working with transformations

Data quality bar

Using Steps sidebar

Data types in Wrangler

Integer data type
Decimal data type
Date data type
String data type
Boolean data type
Empty values

Formatting your data

Integer formatting
Decimal formatting
Date formatting

Using formulas

Quick example
Mathematical operators
Comparison operators
Logical operators

Error handling in Wrangler

Errors in data
Errors occurring during step execution
Step configuration errors
Errors and output

Fixing errors

Fixing data errors
Fixing step execution errors
Fixing step configuration errors

Running jobs in Wrangler

How does Wrangler expression language differ from CTL?

Data types
if function
How to use CTL functions in Wrangler?

List of common functions

Date functions
String functions
Date functions

6. Transformation steps

Data set manipulation steps

Add column
Duplicate column
Delete column
Rename column
Reorder columns
Filter rows based on formula
Sort
Lookup
Calculate formula

Text manipulation steps

Left substring
Right substring
Substring
Trim
Pad left
Pad right
Remove whitespaces
Remove accents
Lowercase
Uppercase
Remove non-alphanumeric characters
Remove non-ASCII characters
Remove non-numeric characters
Remove non-printable characters
Replace text

Error handling steps

Remove rows with errors
Replace errors
Replace empty values
Clear error cells

Math steps

Absolute value
Round step
Truncate
Square root
Exponential
Raise number to a power
Natural logarithm
Common logarithm
Ceiling
Floor
Division remainder

Date manipulation steps

Current date and time

Data conversion steps

Convert to boolean
Convert to date
Convert to decimal
Convert to integer
Convert to string
Convert Unix time to date