COLUMN_LIST
A PARAMETER element with a FIELD attribute equal to "COLUMN_LIST" will display the columns from the schema associated with the component. This is this most common COLUMN_LIST field type used in the standard components.
PREV_COLUMN_LIST
A PARAMETER element with a FIELD attribute equal to "PREV_COLUMN_LIST" will display the columns from the main input schema. The main input schema is defined as the metadata associated with the single FLOW CONNECTOR.
A tFilterRow Using a PREV_COLUMN_LIST |
LOOKUP_COLUMN_LIST
A PARAMETER element with a FIELD attribute equal to "LOOKUP_COLUMN_LIST" will display the columns from the alternate input schemas. The alternate input schemas are defined as the metadata associated with all the flows identified as LOOKUP CONNECTORs. This list of columns combines spans several schemas.
A tJoin Using a LOOKUP_COLUMN_LIST (and PREV_COLUMN_LIST) |
tJoin uses both a PREV_COLUMN_LIST -- to capture the main flow -- and a LOOKUP_COLUMN_LIST to create a join between two data sources.
COLUMN_LIST is a widely used FIELD in the standard Talend component library. However, there are occasions where you'll want to have the user select a column from a different schema. PREV_COLUMN_LIST and LOOKUP_COLUMN_LIST are two FIELD types that will do this for incoming connections.
nice article.
ReplyDeletehow can i add all the input columns automatically to my input table ? without to add each of them manually.