Problem understanding iterator

Hey i have a problem with an iterator function.

Why my google sheet module isn’t doing 2 operations ?

This is the value im putting in the cell i want to get : F{{35.line}} (This is the variable of the line in the output of the iterator)

The goal would be to get the value of the cell F2 and F8 for example but it always giving me only one output (the first one)

Thanks a lot for any help !


Hello @Melv_In,
First, check what input you’ve given to your Iterator. It always needs an Array as input.

In this attached screenshot see that Iterator runs only 1 time. It should be 2 times.
Please cross-check it and share your Iterator input if you can’t get it.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best Answers as Solutions :white_check_mark: and give :+1: If you need expert help or have questions? Contact or comment below! :point_down:

Hi ! First thanks for your answer.

This is the input of the iterator. I also gave you the output of my OpenAI module just before the iterator.
And this is the formula inside the iterator module : {{5.result.matches}} (As you can see in the OpenAI outputs i’m taking an Array as a input for the iterator

Hello,
Can you show me the Iterator settings dialog box?
You need to pass that matches array there.

This is my google Sheet “Get a cell” module after

Hello @Melv_In,

Sorry, I was wrong about that Iterator runs.

I’ve created one basic version of iteration based on your structure.
Make_iterator_testing_blueprint.json (4.2 KB)
Download and check it on your end.

For now all of your settings and structure looks ok.

Still recommend you cross-check check data structure twice. Does it match with what I’ve used on ParseJSON?

:+1:

1 Like

I think im progressing but i still have a problem. Why i can’t get the value variable of the iterator in the google sheet module ?


Hello @Melv_In,
It’s really weird.
But this happens sometimes with Iterators and Aggregators.

Not sure this is fixe, But just hit Save, and close the scenario.
Open it again and run it, Then try to select that value field.
I hope this works.

It doesnt work… If you have any other ideas…
:smiling_face_with_tear:

Can you please share your input data in JSON?

Just for example use this sign(`)
```
{your json data or code}
```

Later it will look like this.

{your json data or code}

I’ll try that on my side.

This is the input of the iterator

[
{
“array”: [
{
“value”: 3
},
{
“value”: 8
}
]
}
]

This is strange.
The data looks :ok:.

As per this new screenshot, Can you please explain that why module 35(Iterator) Total number of several bundles is 3? We’ve given only 2, right?

I dont knoy i’m a bit fed up with this i dont know why its not working and its taking me way too much time…

In the case with 3 bundles i just took another example because i want this to be run X amount of time it can be 1 or 2 or 3 or X. To go get the cell F1 and/or F2 and/or …

I am a begginer so maybe there is another way of doing this so dont hesitate if you have any other ideas

My goal is too just if ChatGPT delivers for example Line number(3; 5; 9) i can go look for the value of the cell F3; F5; F9. It can be only one line number or more than 3

I think i have the solution… after many hours struggling but thanks a lot for our help !!!