DatabaseColumn - 6.3

Talend Data Mapper User Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Studio

Name

DatabaseColumn

Purpose

Specifies a database column value when using another database function.

Description

The DatabaseColumn function is as an argument to other database functions like DatabaseLookup to specify the column name as part of the SQL expression. This function may be used only within the argument expression of the database function.

Return Type

Depends on the database column specified

Property

Column

The fully qualified column in the database of the form: <path to database>.<table>.<column> for example: /Default Project/Databases/MyDatabase.MYTABLE.MYCOLUMN. Note that when using the studio a graphical interface specifies this, so you don't need to be concerned with this format.