How can data transformation be achieved in Quickwork?

Shilpa Rao

• December 06, 2024 08:05

0

• 

  Rajnish Kucheria

  • December 15, 2024 10:17

  Data transformation in Quickwork can be achieved using Formula mode in input fields, which provides a JavaScript sandbox for various manipulations. The Logger app also supports Formula mode, allowing you to transform data directly within your journeys.

  Examples of Data Transformations:

  • Date Formatting: Convert 2024-12-06T10:15:30Z to 06-Dec-2024 10:15 AM.
  • Text case adjustments and string concatenation: Transform "hello world" to "HELLO WORLD" or "Hello World, combine "John" and "Doe" into "John Doe"
  • Arithmetic operations: Perform calculations like 10 + 5 or calculate percentages.
  • Date calculations: Determine the number of days between two dates, for example, 2024-12-01 and 2024-12-06.

  0

Please sign in to leave a comment.