Wednesday, May 12, 2010

Check Table Column Existence in Pentaho

0 comments
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  
image
  1. Drag & Drop the above icon.
  2. image
  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.



0 comments: