acesario
Contributor II
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to identify matching values to create sequence numbers?
No, more like : “Records”: [ { “Award”: [“Award_A”,“Award_B”,“Award_C”,“Award_A,“Award_B”,“Award_C”], “Sequence”: [“01”,“01”,“01”,“02”,“02”,“02”] “Award”: [“Award_A”,“Award_C”,“Award_A”,“Award_B”,“Award_C”], “Sequence”: [“01”,“01”,“02”,“01”,“02”] “Award”: [“Award_Z”,“Award_C”,“Award_A”], “Sequence”: [“01”,“01”,“02”] “Award”: [“Award_B”,“Award_C”,“Award_B”], “Sequence”: [“01”,“01”,“02”] “Award”: [“Award_A”,“Award_B”,], “Sequence”: [“01”,“01”] …1.4KViews0likes0CommentsRe: How to identify matching values to create sequence numbers?
viktor_n: $Records.map(record => {“Award”: record.Award, “Sequence”: record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length.toString())}) When I remove the [0] at the end it does produce all, but it changes the structure from to []. And as I was pushing this to jsonPath($, “$Records[*].Sequence”), it no longer keeps sequence inline with the record.2.9KViews0likes0CommentsRe: How to identify matching values to create sequence numbers?
j.angelevski: [0] @viktor_n , @j.angelevski My initial testing worked with a limited record, however I’m noticing as I apply this to a more extended record structure, how the predicate of [0] impacts this. In this case, it always hits the first record, writing that result to each record. So if the first record has 2 awards, and the next has 5 it creates only two sequences on the second due to the [0]. Any ideas on how to define the predicate for the current record, rather than the first?2.9KViews0likes2CommentsRe: How to identify matching values to create sequence numbers?
j.angelevski: $Records.map(record => record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length).map(val => “0” + val))[0] This worked perfectly… not sure who to give the solution to… Viktor solved the basic approach problem, j dialed in. thanks to each of you!2.9KViews0likes0CommentsRe: How to identify matching values to create sequence numbers?
viktor_n: $Records.map(record => record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length)) @viktor_n Thanks for the response, great use of map approach! One thing I notice is that your resulting Sequence has a separate array for the sequence values [[1,1,2,1,2]] rather than “Sequence”: [“01”,“01”,“02”,“01”,“02”]4.9KViews1like1CommentHow to identify matching values to create sequence numbers?
Looking for a function to help add sequence numbers to a json array. End goal is to apply a sequence to matching values, starting with 01, subsequent values get a sequence of 02…03… 04 etc. I could do this in a mapper, or in apache velocity as part of a soap execute if possible to loop through, and apply therein. What I have now: [ { “Records”: [ { “Award”: [ “Award_A”, “Award_C”, “Award_A”, “Award_B”, “Award_C” ] } ] } ] Desired output: [ { “Records”: [ { “Award”: [ “Award_A”, “Award_C”, “Award_A”, “Award_B”, “Award_C” ], “Sequence”: [ “01”, “01”, “02”, “01”, “02” ] } ] } ]Solved11KViews0likes15Comments