'Is there a step in Pentaho Spoon to use a transformation as inner query?

Transformation example

Is there a way for me to use a transformation like this to use as an inner query in 'table input 4' like using 'insert data from the step' or 'execute sql script'? If not, is my only option using the whole query in the table input step?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source