i want to use a text aggregator to combine some text for each bundle with some conditions.
Essentially i want to get the data from my google sheet that presents in this format. (image input) where the top row is size of the product and the table qty is the qty of that size..
I want to aggregate the text for the attached output on another google sheet (as per output image). I only want to reference the sizes with a value, so where there is no size 10 example, it needs to be ignored.
Keep in mind each style will have different columns with different amounts, i only want the outputs with the amounts where there is greater than 0.
I have it at a stage where i can output the row data (with value more than 0) as an iterator (see below)
Can someone help me to be able to get the text to aggregate as required. Even if someone can build a small version of this i would be happy to expand it. Thanks in advance
this is my iterator output - (one bundle)
[
{
"0": "2512-SLATE",
"1": "Aussie Pacific",
"2": "",
"3": "",
"4": "",
"5": "1",
"6": "1",
"7": "",
"8": "",
"9": "",
"10": "",
"11": "",
"12": "",
"13": "",
"14": "",
"15": "",
"16": "",
"17": "",
"18": "",
"19": "",
"20": "",
"21": "",
"22": "",
"23": "",
"24": "",
"25": "",
"26": "",
"27": "",
"28": "",
"29": "",
"30": "",
"31": "",
"32": "",
"33": "",
"34": "",
"35": "",
"36": "",
"37": "",
"38": "",
"39": "",
"40": "",
"41": "",
"42": "",
"43": "",
"44": "",
"45": "",
"46": "",
"47": "",
"48": "",
"49": "",
"50": "",
"51": "",
"52": "",
"53": "",
"54": "",
"55": "",
"56": "",
"57": "",
"58": "",
"59": "",
"60": "",
"61": "",
"62": "",
"63": "",
"64": "",
"65": "2",
"__ROW_NUMBER__": 6,
"__SPREADSHEET_ID__": "1eypiyer3jeGlK4M-qDdI4R3Qd6nL0950bkcB6FCuFfE",
"__SHEET__": "ItemsCanberra",
"__IMTLENGTH__": 1,
"__IMTINDEX__": 1
}
]
input:
output
