How to segregate values coming from the input into multiple values and map to multiple columns in Talend data mapper
Hi Team,
I have a input json payload coming from source it has multiple values in it which we need to segregate based on either delimiter or key /value pair and map it to different elements in talend data mapper.
EX : Input json element is as below.
"notes": "date: 08/08/2018; status: L; Comment: First comment [2061176]."
In the output we need to map it to date, status, comment separately. We tried with multiple functions but none of them are giving the expected result. Could you please let us know the solution?
