Is there a way to iterate over a combination of parameters using a "for each" task?

sys08001 — Wed, 09 Apr 2025 18:31:33 GMT

Hi,

I have a notebook with two input widgets set up ("current_month" and "current_year") that the notebook grabs values from and uses for processing. I want to be able to provide a list of input values in the "for each" task where each value is actually a value pair corresponding to the widget values e.g. ("January", "2023") and then specify that I want the notebook task to be iterated over using the paired values. I have only been able to find instructions for iterating over values corresponding to a single parameter (e.g. you can provide an input list ["January", "February", etc.] in the for each task and then create a parameter in the notebook task of "current_month" set equal to "{{input}}") and was wondering if what I'm trying to accomplish is possible?

Re: Is there a way to iterate over a combination of parameters using a "for each" task?

ashraf1395 — Thu, 10 Apr 2025 08:02:08 GMT

Hi there @sys08001 , yup it is possible

you can pass the input values for the for_each task in json format
Somewhat like this

[ { "tableName": "product_2", "id": "1", "names": "John Doe", "created_at": "2025-02-22T10:00:00.000Z" }, { "tableName": "product_2", "id": "2", "names": "Jane Smith", "created_at": "2025-02-22T11:00:00.000Z" }, { "tableName": "product_2", "id": "3", "names": "Alice Johnson", "created_at": "2025-02-22T12:00:00.000Z" }, { "tableName": "product_2", "id": "1", "names": "John Doe", "created_at": "2025-02-22T10:00:00.000Z" }, { "tableName": "product_2", "id": "2", "names": "Jane Smith", "created_at": "2025-02-22T11:00:00.000Z" }, { "tableName": "product_2", "id": "3", "names": "Alice Johnson", "created_at": "2025-02-22T12:00:00.000Z" }, { "tableName": "product_2", "id": "1", "names": "John Doe", "created_at": "2025-02-22T10:00:00.000Z" }, { "tableName": "product_2", "id": "2", "names": "Jane Smith", "created_at": "2025-02-22T11:00:00.000Z" }, { "tableName": "product_2", "id": "3", "names": "Alice Johnson", "created_at": "2025-02-22T12:00:00.000Z" }, { "tableName": "product_2", "id": "1", "names": "John Doe", "created_at": "2025-02-22T10:00:00.000Z" }, { "tableName": "product_2", "id": "2", "names": "Jane Smith", "created_at": "2025-02-22T11:00:00.000Z" }, { "tableName": "product_2", "id": "3", "names": "Alice Johnson", "created_at": "2025-02-22T12:00:00.000Z" } ]

and then can in the each task you can use {{input.field_name}}

for you usecase , you can create a json input like this
[ { "month": "January", "year" : "2025" }, ... ]
and then in the each task you can use input.month or input.year to call it,
you can create two separate parameters for calling them or can have them in a single parameter as well
by referencing them like this

( {{input.month}} , {{input.year}} )

topic Is there a way to iterate over a combination of parameters using a "for each" task? in Get Started Discussions

Is there a way to iterate over a combination of parameters using a "for each" task?

Re: Is there a way to iterate over a combination of parameters using a "for each" task?