swatifunde
Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Modify data structure
Hello Community, Currently we have data like this : { “ID”: “ProjectNumber”: “ProjectAllocation”: “Class”: “ClassPlace”: } The desired output is like this: { “ID”:0, “ProjectNumber”:{ “ProjectNumberID”:“string”, “ProjectAllocation”:{ “ProjectAllocationID”:“string” } }, “Class”:{ “ClassID”:“string”, “ClassPlace”:{ “ClassPlaceID”:“string” } “Place”:{ “PlaceID”:0, “PlaceName”:“string” } } } Is there any way we could use to achieve this in SnapLogic ?1.7KViews0likes1CommentFilter the data
Hello Community, Below is input [ { “name”=“ABC” “ID”=“D.0012” }, { “name”=“XYZ” “ID”=“B.002” }, { “name”=“OPQ” “ID”=“E.0012” }, { “name”=“LMN” “ID”=“J.0012” }, { “name”=“DEF” “ID”=“C.0012” }, { “name”=“RST” “ID”=“B.05” } ] I have millions of records like this , I want to filter them based upon one key named as “ID”: and need the data for only the object which have “J.” or “C.” and discard all the rest IDSolved2.9KViews0likes3Comments