I am trying to achieve the following in Kettle:

insert into result_table select a.value, b.value, c.value from table_a a, table_b, b, table_c, c;

The names of the tables as well as the number of tables are determined at run time. Essentially, I want to parameterize the table list and the select attribute list as follows:

insert into result_table select ${attribute_list} from ${table_list}

I tried using Kettle variables without any luck. Could you kindly point me in the right direction?

Thank you