dd_snaplogic
New Contributor II
Joined 3 years ago
User Profile
User Widgets
Contributions
How to check object exists in an array
I have an array eg { “groupBy”: { “rowKey”: “0141116963814” }, “group”: [ { “rowKey”: “0141116963814” }, { “rowKey”: “0141116963814” }, { “rowKey”: “0141116963814” } ] } Now I’m accessing each element of group in mapper and I require to have the null-safe access check enabled. Now if I’m trying to check whether the group array have object in 7th position ie jsonPath($, “$group[6].rowKey[0]”) but, i’m getting null as a response I’ve tried using various ways (eg. sl.ensureArray(jsonPath($, “$group[6]”))) but it seems when null-safe access check is enabled nothing works What is the way to check whether the element or object exists?Solved4.9KViews0likes4CommentsRe: How to use join snap to get NOT a match data
@bojanvelevski Yes i saw that options of sending unmatched data in error view, but that will also send the data to my error pipeline so route options to error view is not an option. At the end i used the path similar to what @koryknick suggested. used left outer join and with a filter $input1_abc ==null as my condition for unmatched data. I do remember earlier it was not like that, I could use !(NOT) condition in the path itself and it used to work.4KViews0likes0CommentsRe: How to merge all objects in an array
@j.angelevski Under the group object if I have same key, for example this example as you can see it has same key, so if i use extend function it will override the value with the same key Is it possible to keep all the values and generate the matching keys dynamically in the same object. example: Here is the example slp file Example Groupby Merge.slp (6.6 KB)2.3KViews0likes1CommentHow to use join snap to get NOT a match data
I’m using join snap to with a condition NOT, surprisingly the validation is giving me output, but when i’m running the pipeline it is giving me an error, Can someone please help me understand what i’m doing wrong ERROR message: Not comparable objects: String abc and Boolean false5KViews0likes5Comments