Tale of Data Cookbook

The thematic pages below are from our Tale of Data Cookbook 📒.

They are in the form of Q&A, based on questions that have been asked by Tale of Data users to our helpdesk. We have grouped them by theme to make their discovery easier ✨!

Supervision and Monitoring

• Next date and time of execution for flow sequences
• Send an email alert with Tale of Data
• Flow execution scheduling with Cron

Tale of Data GUI

• Find a specific group in the list of groups on the List Flows page
• Select only two columns instead of a range in the preparation editor
• How to display Timestamps in milliseconds within Tale Of Data?
• What does the FILTERS section mean in the documentation of the preparation editor ?
• Is it possible to upload compressed files?
• How does the Data Preview in ToD work?

Connections and Data Sources

• Azure Data Lake Storage Connector
• Add the file name where the data comes from in a column of the dataset?
• How do you map columns from one file to another?
• How to merge flows into a single table?

ToD Specialties

• How to read SAB dates?
• Create a column with the value of a variable at the time of the flow execution
• Fields and search groups in the repositories
• Group duplicate entries by creating a lookup key
• Where is the bulk data migration feature in ToD?

Data Processing

• Extract from a text column all the words in each line containing a certain pattern
• Matching Columns Across Multiple Datasets
• Is it possible to merge rows in Tale of Data?
• Detecting Bad Values
• Validate the type of a column
• Business rule to detect if a field does not match a regular expression
• Round the decimals
• How to normalize timestamp and timezone errors?
• Using generative AI for processing DATE type fields
• Case-insensitive sorting of a list