Advanced Transformations and Formulas

October 09, 2017

How to use formulas for transforming data in recipes

Whether you are a beginner or an advanced user of Workato, you will be working with multiple data types e.g. timestamps, date,numbers,strings,lists, JSON etc. More often than not these data types will need to be transformed e.g. formatting a date, extracting the date component from a timestamp, converting timestamp to date, adding or extracting timezone component, converting a numeric datatype to date or string, extracting individual data values from a list or creating a list from a set of values, splitting a string by pattern or position, concatenating multiple strings etc.

Workato has 400+ built-in formulas that allow you to transform data for your use case. Join us to learn about some common data transformation use cases and challenges.

Related articles

June 7, 2017Advanced Mappings and TransformationsOverview
Recipes move data from one app to another. In order to do so, a recipe includes:
Connections - this setup provides access to read data from and write data into apps
Steps […]Posted in Past Webinars

May 22, 2017Advanced Trigger ProcessingWhat is a Trigger?
Trigger is needed to nudge the recipe to wake up and look for business events to process.
Examples:
New contacts added in Google Sheets (327706)
New tickets […]Posted in Past Webinars

April 22, 2017Advanced List ProcessingLearn more about how you can format lists for display, search and join, pluck to process a subset of the data pills in a list, perform arithmetic operations (sum, average etc), charting […]Posted in Past Webinars