:bullseye: What is your goal? I want to take the JSON output returned by OpenAI for every row, then group all items by Category, concatenate all vendor names in that category, and sum all TotalSpent values. :thinking: What is the problem & what have you tried? I tried using Iterator → Array Aggrega…

What I want After processing all rows, I need this output: { "Category": "Medical", "VendorList": "ABC, XYZ, KLM", "TotalSpent": 25000 } Meaning: Group all records by Category Join vendor names in that category Sum TotalSpent values Output one bundle per category

Hi Jayesh, It looks like the results from the Google Sheet is creating 3 bundles which are then being processed one at a time by ChatGPT. If you add an array module after ChatGPT (rather than an Iterator) you’ll be able to combine all of the data back into one Array. From there if you pass the Ar…

Replace the iterator with an aggregator, set the source module to the search module and not the openai one, then change the grouping to Category.

You don’t need both the array and the text aggregator, it’s either or.

[image] Jayesh_Makhar: openAI return 3 output- and the group by cetagory is not working. it return 3 items in the end. but it still not work. You’re really close. The main issue is what you’re aggregating. Right now you’re trying to aggregate directly from the OpenAI module, where the da…

Again - you aggregate the module producing the extra bundles. In your case that is the 1st module in the scenario, the Search module. Change the source module for the aggregator.

Need help in logic

Questions

Jayesh_Makhar November 21, 2025, 6:42am 7

openAI return 3 output-
and the group by cetagory is not working.
it return 3 items in the end.
but it still not work.

Topic		Replies	Views
How to summarize quantities of sold products by grouping by category Questions aggregators , arrays	9	355	January 24, 2024
How do I aggregate operations? (Please, I need help) Questions connections , error , operation	12	71	January 23, 2026
Combine two results Questions aggregators	3	206	March 18, 2025
ChatGPT Text Aggregator Beginner Questions aggregators , arrays , scenario	5	386	October 18, 2024
Bug: Google Sheets -> Aggregator -> ChatGPT Questions mapping , arrays , open-ai	3	34	August 20, 2025

Need help in logic

Related topics