Kettle Job Call transformation, set variable, write log to database "Go"

First, convert: from database tables to logs

Table Input Settings: Log settings: New job: Conversion Select the output log conversion that you just built. The variable is set as follows: This ID is the ${id} in the conversion, the job is executed, you can see the console output log results: Only one record of Id=1 is written in the Black Font section. Finally, write the converted log to the database: Open Transformations >ctrl+t> logs tab > convert > Click SQL below to execute SQL build table. After the job is executed, the log records are written to the database.

Kettle Job Call transformation, set variable, write log to database "Go"