cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to map multiple target path to single field name

nirupama
New Contributor II

Hi all,

I have a sample data as below:
โ€œTRANSCU2โ€:

โ€œT1โ€

โ€œTRANSCU3โ€:

โ€œT4โ€

โ€œTRANSCU4โ€:

โ€œT8โ€

โ€œTRANSCU6โ€:

โ€œT90Hโ€

โ€œTRANSCU7โ€:

โ€œT67โ€

โ€œTRANSCU8โ€:

โ€œT653โ€

But i wanted to map all source field to single target path like below:
โ€œCUโ€:โ€œT1โ€
โ€œCUโ€:โ€œT4โ€
โ€œCUโ€:โ€œT8โ€
โ€œCUโ€:โ€œT90Hโ€
โ€œCUโ€:โ€œT67โ€
โ€œCUโ€:โ€œT653โ€

Please suggest.

1 ACCEPTED SOLUTION

koryknick
Employee
Employee

Allow duplicate names in a JSON object is generally not recommended as a JSON standard and SnapLogic doesnโ€™t allow it. You could, however, translate the object into an array of values using some simple expression syntax such as the following:
image

image

I hope this helps!

View solution in original post

2 REPLIES 2

koryknick
Employee
Employee

Allow duplicate names in a JSON object is generally not recommended as a JSON standard and SnapLogic doesnโ€™t allow it. You could, however, translate the object into an array of values using some simple expression syntax such as the following:
image

image

I hope this helps!

nirupama
New Contributor II

@koryknick It helped, Thanks. I used json splitter after this and then mapped it to single target path.