06-19-2019 08:24 AM
I’m trying transform the data as below using mapper. Could someone please let me know how this can be done with mapper snap.
Input Schema:
[
department_Id: number,
details: [
{ firstname: string, lastname: string, id: number},
{ firstname: string, lastname: string, id: number}
]
]
Expected Output Schema:
[
department_Id: number,
details: [
{ name: string = firstname+ " "+ lastname, id: number},
{ name: string = firstname+ " "+ lastname, id: number}
]
]
Solved! Go to Solution.
06-20-2019 07:54 AM
Think this does what you’re looking for.
I used the first mapper to re-map the entries in the details array and then the second mapper to rename the details property to users.
Here is what I was mentioning about using the Mapping Root. This is very helpful for working with nested arrays.
Here is the complete example for you to try out. Good luck with your work.
make-users_2019_06_20.slp (5.5 KB)
06-20-2019 07:54 AM
Think this does what you’re looking for.
I used the first mapper to re-map the entries in the details array and then the second mapper to rename the details property to users.
Here is what I was mentioning about using the Mapping Root. This is very helpful for working with nested arrays.
Here is the complete example for you to try out. Good luck with your work.
make-users_2019_06_20.slp (5.5 KB)
06-21-2019 12:28 AM
Thanks. It is working as expected