Data Manipulation using List Formula (Additional)

SUMMARY: 🔔To use formulas in Workato, activate formula mode at the field level. 🔔Formula mode provides approved formulas and guidance for data manipulation. 🔔The editor shows type-specific formulas based on the data-pill type in an input field. 🔔Text must be explicitly formatted in formula mode, unlike in text mode. Topic: Modify Recipe Data with additional List Formulas In this session, we talk about List formulas. 📚1. pluck Retrieves only the columns which have been specified. 📚2. join Combines all items in a list into a text string. A separator is placed between each item. 📚3. smart_join Joins list elements into a string. Removes empty and nil values and trims any white space before joining 📚4. concat Concatenates 2 lists into a single list. Nested lists will NOT be flattened 📚 Previous Session Link: https://youtu.be/_QHfsnOmSXk Find #Workato everywhere! ► Website: www.workato.com ► Twitter: https://twitter.com/workato ► LinkedIn: https://www.linkedin.com/company/workato/ ► Instagram: https://www.instagram.com/workatohq/?... 🔔Got suggestions for topics? Leave your comment down below or drop us a note at [email protected]