JOLT - Join nested arrays

Question

I'm trying to join (comma separated) a nested array but cannot achieve it.

Input:

{
    "PARTS" : [ [ "aaaa", "bbbb" ], [ "cccc", "dddd" ] ]
}

Desired output:

{
    "PARTS": [ "aaaa,bbbb", "cccc,dddd" ]
}

I am trying to use =join but yet unsuccessful. Any help is appreciated.

Thanks!

Dharman · Accepted Answer · 2021-04-20 10:13:12Z

1

I managed to get the output you were aiming for :)

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "PARTS": {
        "*": "=join(', ',@0)"
      }
    }
  }
]

The trick here is using @0, which points to the 0-th element on the hierarchy you're working with. At least, that's what the documentation says.

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Apr 20, 2021 at 10:08

vikepic

614 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1