I’m almost a newbie in Toad data point, and i need your help to build an automation.
I’ve a Toad report (.tdr) with a query of the type " select XXX,YYY from schema.table where XXX= a variable".
I woul like to create an automation with a loop dataset that will execute and save the report for each value returned by the Loop dataset query as XXX in the report query.
How can i link the variable in the report’s query to the variable generated by the query of the loop ?
Thanks a lot for your help.