twigfiddle.com - Fiddle ysqkxs v1 - Created on August 13, 2019 09:36

More options...

Title

File

{% set output = {} %}

{% for raw in data %}
	{% if not attribute(output, raw._id.cityName) is defined %}
        {% set output = output|merge({ (raw._id.cityName) : {}, }) %}
    {% endif %}

    {% if not attribute(output[raw._id.cityName], 'id_'~raw._id.id) is defined %}
        {% set output = output|merge({(raw._id.cityName) : output[raw._id.cityName] | merge({('id_'~raw._id.id):[], }) }) %}
    {% endif %}

    {% set output = output|merge({(raw._id.cityName) : output[raw._id.cityName] | merge({('id_'~raw._id.id): output[raw._id.cityName]['id_'~raw._id.id]|merge({(raw._id.className): raw.count}), }) }) %}
{% endfor %}


{{ output.foo.id_42.alpha }} {# output: 40 #}

Format

{"data":[{"_id":{"cityName":"foo","className":"alpha","id":42},"count":40},{"_id":{"cityName":"bar","className":"alpha","id":55},"count":123},{"_id":{"cityName":"foo","className":"beta","id":42},"count":99}]}

Fiddle ysqkxs created on August 13, 2019 09:36 and visited 427 times

Developed using

Not logged in.

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