Value Setter: how to reference nested object using current id

[vosy]

{
    "items":[
        {
            "id":"aaa",
            "translations":{
                "aaa":{
                    "new_id": "some text aaa"
                },
                "bbb":{
                    "new_id": "some text bbb"
                },
                "ccc":{
                    "new_id": "some text ccc"
                }
            }
        },
        {
            "id":"bbb",
            "translations":{
                "aaa":{
                    "new_id": "some text aaa"
                },
                "bbb":{
                    "new_id": "some text bbb"
                },
                "ccc":{
                    "new_id": "some text ccc"
                }
            }
        },
        {
            "id":"ccc",
            "translations":{
                "aaa":{
                    "new_id": "some text aaa"
                },
                "bbb":{
                    "new_id": "some text bbb"
                },
                "ccc":{
                    "new_id": "some text ccc"
                }
            }
        }
    ]
}

how to use Value setter to create “new_id” with value somethink like translations[id].new_id

result like

{
    "items":[
        {
            "id":"aaa",
            "new_id":"some text aaa",
            "translations":{
                "aaa":{
                    "new_id": "some text aaa"
                },
                "bbb":{
                    "new_id": "some text bbb"
                },
                "ccc":{
                    "new_id": "some text ccc"
                }
            }
        },
    ....
    ]
}

[m.arief]

Hi @vosy ,

Indeed that would be easier to do with something like translations[id].new_id or translations[&{id}].new_id
But unfortunately, it is not possible to use a variable expander inside another variable expander.
As for your case, you can achieve by doing these “Node transform nodes” transformer.

1. Create a Node transformer
   

   

2. Create a value Setter (to create a same structure so it can be compared with the “translations” data)
   

   

3. Value setter to compare the keys
   

   

4. Put the intersected value as a result
   

   

As the result you’ll get this :

Let me know if this is not the result that you’re expecting.