Table Input with select records, to include the WHERE clause

I would like to read an SQL table using the WHERE clause and use a local variable. Not the Global Variable which would be the ${Variable}.
How can I include such a variable within the SQL Statement?

You can refer this highlighted image. Where “path” is variable coming from previous step.

What I understand with this suggestion, with the Table Input RA, no variables, either global or local, can be past to select a number of records.

The documentation suggest that instead of full SQL statement RA, input/output/update SQL RA would be the preferred method as these are optimized.

In our present case, very few records will be read, so this RA should do it.


1 Like