Here is a straightforward jq translation def stores: [ { "store number" : 1, "state" : "MA" }, { "store number" : 2, "state" : "MA" }

Here is a straightforward jq translation def stores: [ { "store number" : 1, "state" : "MA" }, { "store number" : 2, "state" : "MA" }, { "store number" : 3, "state" : "CA" }, { "store number" : 4, "state" : "CA" } ]; def sales: [ { "product" : "broiler", "store number" : 1, "quantity" : 20 }, { "product" : "toaster", "store number" : 2, "quantity" : 100 }, { "product" : "toaster", "store number" : 2, "quantity" : 50 }, { "product" : "toaster", "store number" : 3, "quantity" : 50 }, { "product" : "blender", "store number" : 3, "quantity" : 100 }, { "product" : "blender", "store number" : 3, "quantity" : 150 }, { "product" : "socks", "store number" : 1, "quantity" : 500 }, { "product" : "socks", "store number" : 2, "quantity" : 10 }, { "product" : "shirt", "store number" : 3, "quantity" : 10 } ]; [ {store: stores[], sale: sales[]} | select(.store."store number" == .sale."store number") | { nb: .store."store number", state: .store.state, sold: .sale.product } ] Try it online - https://tio.run/##rZPPUsMgEMbP5Sl2ctIZmklbe6HTg@PZJ8jkkD84RhEsbA5O9dkxobQqjTHpyIWw@fbHfrA87ayFdlT8AQwqzQ0j4EbqZ4A9RO4XyOal4DoCBgvaxXLk3SK6v43ggw7plxP1qx/6uz/1N@d6L8825OQvF7/Ye9Wqakp0yYVWtWiptN/1rskl1vjmXCUQ1PUdhCo32A9aBqBFkvwPaH0hZzWFUwguq3GcYWNTQIMVGVU@mzE3tk4uwpzf1xDlsdY47nDCLiVBZzoC8w8zzahrYXZo5DQ7Jr@D4YKXeBU7YRxsvN1C3GUE8etT9h5kwbrP3vwvnwDuibGjzq0ombVxJSrmd/FHQWaH8jJirZ3L8hM https://tio.run/##rZPPUsMgEMbP5Sl2ctIZmklbe6HTg@PZJ8jkkD84Rh...