How to pass fields to pentaho update step using metadata injector?

Question

I am using pentaho 7.1 which supports metadata injector for update step. Can anyone help me how to pass multiple fields and its values simultaneously using metadata injector

Answer 1

You need multiple streams of data with varying numbers of rows feeding data into the metadata injection step:

• a single row of data to inject single valued things such as the table name or step properties;
• a multi row data stream with the field names to use in the lookup part;
• another multi row data stream with the list of fields to update.

See https://www.youtube.com/watch?time_continue=101&v=EjzgzOanq1o for a tutorial by none other than Matt Casters.

To iterate over multiple tables I suggest you run the transformation multiple times, once for each table to update, fetching the metadata to inject from a text file, or a config table.