Run a scenario within a scenario

[yazidsaissi]

Hi,

I have a scenario that run my flow for a single day and I want to create another scenario that run it for multiple days using a python script.

For example:

Scenario 1 run for day 1

I want to create another scenario like:

while i >= start_date and i <= end_date:

   Run Scenario 1 for day i

Does anyone has an idea about how to do it ?

Thanks

[Turribeach]

Running a scenario it's easy:

client = dataiku.api_client()
client.get_project("project_key")
scenario = project.get_scenario("scenario_id")
scenario.run_and_wait()

 In terms of your date it depends on how you are going to pass it, so you will need to give us more information to understand how it is being handled. 

[yazidsaissi]

Thanks for the answer.

For the date, it's global variable.

At the beginning of my flow, I have a SQL recipe, where I'm filtering my table using the date varibale (the query is like select * from table where date = '${date}') and at the end of my flow, I append the results in a dataset. 

Now instead a having just one date variable, I will have a start and end date variables, and I want to run the precious scenario for each day between the 2 dates and then append the results to the final table.

I hope i was clear.

Thanks