DB Type Mapper

Change the database to KNIME type mapping configuration for subsequent nodes based column name and database type or only database type. The dialog allows you to add new or change existing type mapping rules. It does not allow you to delete existing mapping rules. All rules from the input DB Data port that are not changed in the node dialog and forwarded unaltered to subsequent nodes e.g. if one of thes mappings changes in a predecessor node these changes are propagated to all subsequent nodes of the DB Type Mapper node.

Options

Mapping by Name

Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.

Mapping by Type

Columns that match the given database type will be mapped to the specified KNIME type.

Views

This node has no views

Workflows

• 16_Database_Structure_ManipulationKNIME Hub
• 16_データベース構造の操作KNIME Hub
• betaKNIME Hub
• DB_practice_v01KNIME Hub
• HSON to PGKNIME Forum
• Modify Database Tables from KNIME Analytics PlatformKNIME Hub
• PostgresJSONKNIME Hub
• Rossmann - DB - Time SeriesKNIME Hub
• Rossmann - DB - Time Series(2)KNIME Hub
• SQLServer_GeoKNIME Forum

Links

• No links available

Developers