twigfiddle.com - Fiddle lohde6 v1 - Created on March 31, 2020 17:21

More options...

Title

File

{% set reportRecords = reportRecords|reduce(
   (rv, x) => rv|default({})|merge({
     ('_'~x['AX']): {
       'records': rv['_'~x['AX']]['records']|default([])|merge([x])
     }
   })
) %}

{% set reportColumns = ['AX'] %}

{% autoescape false %}
{%- for vatId, reportRecord in reportRecords %}
    {%- for record in reportRecord['records'] %}
        {%- for column in reportColumns %}

            {{~ '"'~record[column]|default(' ')~'"' }}{% if not loop.last %},{% endif %}
        {%- endfor %}
    {%- endfor %}
{%~ endfor %}
{% endautoescape %}

Format

{

  "reportRecords": [
    {
      "id": 1,
      "AX": "NL0"
    },
    {
      "id": 2,
      "AX": "NL0"
    },
    {
      "id": 3,
      "AX": "NLA"
    },
    {
      "id": 4,
      "AX": "NLB"
    },
    {
      "id": 5,
      "AX": "NLA"
    }
  ]
}

Fiddle lohde6 created on March 31, 2020 17:21 and visited 35 times

Developed using

Not logged in.

twigfiddle.com @ 2024
Ask a question on Stackoverflow Report issue Download source code