Feel like I’ve tried literally every single permutation of as Date format, as String as Date, as String, etc. What on earth am I doing wrong? Trying to feed data into SF from a CSV. Simple birthday field. Comes in as: 10/29/2003 in an Excel column. Keep getting this error: Cannot coerce String (11/17/1993) to… Read More Cannot coerce String (11/17/1993) to Date

I am trying to execute a find function on a payload. Suppose I have : ["john","abe","john","doe","peter"] The expected output is [ "john", "john", "peter" ] I tried to do ["john","abe","john","doe","peter"] find "john" or "peter" but it doesn’t work. I don’t know how to do it. >Solution : You can use the filter() function to find… Read More Find expression with two parameters in dataweave

I am trying to achieve the below output from the given input. I have tried several ways of making a generic function so that when any data is passed with similar structure I get the similar output. Please help me to achieve this. Input [{ "name": "Thinker", "details": [ { "num": 1 }, { "num":… Read More Extract the inner field objects and apply them to respective top level objects using Dataweave2.0