# merge json\_query output **URL:** \ **Category:** Ansible Project\ **Created:** [March 23, 2021, 12:02pm UTC](https://forum.ansible.com/t/merge-json-query-output/34835 "2021-03-23T12:02:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Sakshi\_Rathore](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sakshi\_Rathore](https://forum.ansible.com/u/Sakshi_Rathore)\ **Post date:** [March 23, 2021, 12:02pm UTC](https://forum.ansible.com/t/merge-json-query-output/34835/1 "2021-03-23T12:02:25Z")
hello all, i am getting 2 array of ips from 2 different json queries in ansible-playbook. how can i merge these 2 json queries? in below example i want to merge jmesquery and jmesquery1 - name: master ip list from json content #debug: msg=“{{ input | json\_query(jmesquery) }}” copy: content=“{{ input | json\_query(jmesquery) }}” dest=…/ip\_address.txt vars: input : “{{ lookup(‘template’, ‘…/cluster.txt’) }}” target: “{{ input | json\_query(jmesquery) }}” jmesquery: “[\*].master\_group.nodes.private\_ip” - name: worker ip list from json content #debug: msg=“{{ input1 | json\_query(jmesquery1) }}” copy: content=“{{ input1 | json\_query(jmesquery1) }}” dest=…/ip\_address1.txt vars: input1 : “{{ lookup(‘template’, ‘…/cluster.txt’) }}” target1: “{{ input1 | json\_query(jmesquery1) }}” jmesquery1: “[\*].node\_groups.nodes.private\_ip” please advise. ---
**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\ **Post date:** [March 23, 2021, 12:10pm UTC](https://forum.ansible.com/t/merge-json-query-output/34835/2 "2021-03-23T12:10:31Z")
What do you mean by 'merging json queries'? I know json data structures can be merged, but queries? For example you can merge input and input1 into a new structure, and then have a single json\_query? Or ....? ---
**Author:** ![Sakshi\_Rathore](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sakshi\_Rathore](https://forum.ansible.com/u/Sakshi_Rathore)\ **Post date:** [March 23, 2021, 12:15pm UTC](https://forum.ansible.com/t/merge-json-query-output/34835/3 "2021-03-23T12:15:24Z")
currently i am getting output in 2 different array: (ip addresses are dummy) [‘10.32.142.156’, ‘10.32.142.153’, ‘10.32.31.177’, ‘10.32.31.176’, ‘10.32.31.175’, ‘10.32.31.180’, ‘10.32.31.179’, ‘10.32.143.174’, ‘10.32.143.173’, ‘10.32.143.175’, ‘10.32.141.40’, ‘10.32.141.37’, ‘10.32.41.155’, ‘10.32.41.154’, ‘10.32.41.156’, ‘10.32.142.157’, ‘10.32.142.161’, ‘10.32.142.162’, ‘10.32.142.151’, ‘10.32.142.160’, ‘10.32.144.166’, ‘10.32.144.164’, ‘10.32.144.167’, ‘10.32.144.173’, ‘10.32.144.172’, ‘10.32.50.177’, ‘10.32.50.176’, ‘10.32.50.178’, ‘10.32.141.3’, ‘10.32.141.2’, ‘10.32.141.7’, ‘10.32.141.8’, ‘10.32.141.17’, ‘10.32.30.195’, ‘10.32.30.196’, ‘10.32.30.193’, ‘10.32.30.194’, ‘10.32.142.194’, ‘10.32.142.193’, ‘10.32.141.66’, ‘10.32.141.68’, ‘10.32.141.103’, ‘10.32.141.102’, ‘10.32.40.154’, ‘10.32.40.155’, ‘10.32.40.156’, ‘10.32.51.155’, ‘10.32.51.156’, ‘10.32.51.157’] [‘10.32.142.156’, ‘10.32.142.153’, ‘10.32.31.177’, ‘10.32.31.176’, ‘10.32.31.175’, ‘10.32.31.180’, ‘10.32.31.179’, ‘10.32.143.174’, ‘10.32.143.173’, ‘10.32.143.175’, ‘10.32.141.40’, ‘10.32.141.37’, ‘10.32.41.155’, ‘10.32.41.154’, ‘10.32.41.156’, ‘10.32.142.157’, ‘10.32.142.161’, ‘10.32.142.162’, ‘10.32.142.151’, ‘10.32.142.160’, ‘10.32.144.166’, ‘10.32.144.164’, ‘10.32.144.167’, ‘10.32.144.173’, ‘10.32.144.172’, ‘10.32.50.177’, ‘10.32.50.176’, ‘10.32.50.178’, ‘10.32.141.3’, ‘10.32.141.2’, ‘10.32.141.7’, ‘10.32.141.8’, ‘10.32.141.17’, ‘10.32.30.195’, ‘10.32.30.196’, ‘10.32.30.193’, ‘10.32.30.194’, ‘10.32.142.194’, ‘10.32.142.193’, ‘10.32.141.66’, ‘10.32.141.68’, ‘10.32.141.103’, ‘10.32.141.102’, ‘10.32.40.154’, ‘10.32.40.155’, ‘10.32.40.156’, ‘10.32.51.155’, ‘10.32.51.156’, ‘10.32.51.157’] i would like to merge these ips into a single array. and how can i merge input and input1? ---
**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\ **Post date:** [March 23, 2021, 2:05pm UTC](https://forum.ansible.com/t/merge-json-query-output/34835/4 "2021-03-23T14:05:04Z")
[https://docs.ansible.com/ansible/latest/user\_guide/playbooks\_filters.html#selecting-from-sets-or-lists-set-theory](https://docs.ansible.com/ansible/latest/user_guide/playbooks_filters.html#selecting-from-sets-or-lists-set-theory) ---
**Author:** ![Sakshi\_Rathore](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Sakshi\_Rathore](https://forum.ansible.com/u/Sakshi_Rathore)\ **Post date:** [March 24, 2021, 11:56am UTC](https://forum.ansible.com/t/merge-json-query-output/34835/5 "2021-03-24T11:56:32Z")
thanks for the advice 🙂