Check Table Column Existence in Pentaho

In order to find out the existence of a specific column in a database use the Check if Column Exists Step available under the Lookup Folder in the design mode  

1. Drag & Drop the above icon.
2. 
3. Double click the step and name it , defined the connection for MYSQL or SQL SERVER etc.
4. Table Name: The name of the column to whom the column belongs.
5. Table name in  Field: Enabled it if you want to read the name of the table from the input field.
6. Tablename Field:Set fields here that have parameters and its type 
7. Columnname Field:Set the name of the column field reading from the input field.
8. Result fieldname:Resulting Boolean flag  that shows weather it exist or not.

read more