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

[viktor_n]

My recommendation is to learn as much as you can of them, but I think most of the times are used Arrays, Strings, Objects, Dates.

[tlikarish]

The Expression Language is loosely based off of JavaScript expressions, so you could use JavaScript resources to try and learn some of them better. The official documentation for the language is here and we try to give some examples, although maybe they could be flushed out more. There is also a section of this community dedicated to learning it, but there isn’t a whole lot of content yet.

[tlikarish]

Here’s another great resource related to learning the Expression Language, where @koryknick goes over his starter pack in a video tutorial.

SnapLogic – 31 Jul 20

Getting Started with SnapLogic Expression Libraries

In SnapLogic Community Office Hours this month, SnapLogic Senior Professional Services Engineer Kory Knickerbocker presented the Expression Library Starter Pack ...

[j_angelevski]

@acesario , I am not sure I understood what you mean by that ? Maybe you want something like this ?

[acesario]

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