How to identify matching values to create sequence numbers?

[acesario]

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”
]
}
]
}
]

[acesario]

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?

[viktor_n]

Just remove [0] at the end.

[acesario]

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.

[acesario]

This is great, I need to learn the map method much better I see. I found an initial tutoral here JavaScript Array map() Method, any other learning recommendations?

[acesario]

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!