Good afternoon, I’m using an Excel Reader to read data from an excel file. I need to use those data as input parameters to a DB SQL Executor. How can I do that, since the output of the Excel Reader does not match the input of the DB SQL Executor?
Hi, thanks for the response. I could read and use a line from a sheet with the variables, but one single line at a time.
In fact , I need to iterate through all the lines of the sheet. I see that there is a component “Table Row to Variable Loop Start” that has the variables “currentIteration” and “maxIterations” that are given to DB SQL Executor (see figure below), but I don’t know how to iterate with it.