Skip DB table if a column is not there

Skip DB table if a column is not there

What it does it lists all the databases table1 - table4. Three tables have the column “sales” one does not. The Loop would extract all structures from every table and see if a column “sales” is there. If yes the DB would be loaded, if not the database is skipped.

External resources

• forum entry
• Iris - check if column is there
• Vernalis Nodes for KNIME (trusted extension)
• HUB: This workflow demonstrates how to use the new Excel Reader and path variables and read Excel sheets and skip a step when a file is missing
• HUB: Skip DB table if a column is not there