The following example shows how a MySQL object record can be looked up using the MySQL Lookup Snap and record the data using the MySQL Execute Snap. In this pipeline, the MySQL Lookup Snap retrieves data from a table called 'Test1'.

The MySQL Execute Snap executes a select SQL statement to get the information from table Test1.

The MySQL Lookup Snap runs the lookup query on, and the lookup conditions specify the column names to be looked up in the look-up table Test1.

Additionally, in the Output fields, select the names of the specific output field name(s) for the output preview to contain only those fields ('isactive' 'id') to be recorded on the target table.

Successful execution of the pipeline displays the below output preview: