cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation for data

walkerline117
Contributor

Hi…

We have below requirment:

Original data from data soure(e.g. database)
image

Here’s what we need to transform to:
image

Appreciate any kind of suggestions.

Thanks
Han

5 REPLIES 5

nganapathiraju
Former Employee

Do something like the below steps.

  1. In the Mapper - Errors.split(‘.’) - but it will not split when you have only one error. You need to come up with some logic there.
  2. add a JSON splitter and
  • split in on Errors
  • use scalar parents checkbox or add the path you want to. The former should work for this.