The transfer of the variable to the query Pentaho

Question

I have job where I want to transfer max_id with query to other query.

In table input I have query

select max(uid) from table_1

in Set Variables I have

And I want to transfer variables to other table

In Table Input I have query:

select * from table2 where uid BETWEEN 407043 and ${MAX_UID}

But it doesn't work

Answer 1

You don’t need the Get Variables step. Just use that query and don’t forget to check the “replace variables in script” box.