Igor_Bozhinovsk
New Contributor III
Joined 5 years ago
User Profile
User Widgets
Contributions
Check if field inside array has value and route the output
[ { “items”: [ { “test”: " ", “id”: 1 }, { “test”: “test”, “id”: 2 } ] } ] Currently we have an array like this , we need to route the output from the Router based on the test field , if there is a value the output should go to the upper branch if there is not value for the test field the output should go to the lower branch. Is there any array method or something else that can be used to achive this ?Re: How to create new array if there are more than 100 elements in the array
Thanks Alchemiz , the array is now spliited in two. One array with 100 elements and the other with the remaining elements. This is the current output : "ShipmentCreateDate": "01/01/2023", "ShipmentID": "1", "SerialNumbers": [ [ { "SerialNo": "123" }, { "SerialNo":"456" } ], [ { "SerialNo": "101" }, { "SerialNo": "102" } ] ] I was wondering if something like this output is possible : "ShipmentCreateDate": "01/01/2023", "ShipmentID": "1", "SerialNumbers": [ [ { "SerialNo": "123" }, { "SerialNo":"456" } ] "ShipmentCreateDate": "01/01/2023", "ShipmentID": "1", "SerialNumbers": [ [ { "SerialNo": "101" }, { "SerialNo": "102" } ] ] Where the first output would be the array with the 100 elements and the remaining fields that are not part of the array and the second output would be the array with the remaining elements and the fields that are not part of the array. Regards, Igor2KViews0likes2CommentsHow to create new array if there are more than 100 elements in the array
Hi , currently we have an array that contains more then 100 elements , approximately 168. Is it possible with some transformation in the mapper to create another array that will contain the rest 68 elements ? We would have 1 array with 100 elements and the other should contain the rest of the elments. Or we can split the array if there are more then 100 documents , that would work too.SolvedMap Json Structure
Currently we have json data like this : { “Test”: “1” “SerialNumbers”: { “SerialNo”: [ “123”, “456” ] } The desired output is like this: { “Test”: “1” “SerialNumbers”: [ {“SerialNo”: “123”}, {“SerialNo”: “456”} ] } Is there any function we could use to achive this in SnapLogic ?Solved