Extracting and filtering data - 7.3
CombinedSQL
- EnrichVersion
- Cloud
- 7.3
- EnrichProdName
- Talend Big Data
- Talend Big Data Platform
- Talend Data Fabric
- Talend Data Integration
- Talend Data Management Platform
- Talend Data Services Platform
- Talend ESB
- Talend MDM Platform
- Talend Open Studio for Big Data
- Talend Open Studio for Data Integration
- Talend Open Studio for ESB
- Talend Real-Time Big Data Platform
- EnrichPlatform
- Talend Studio
- task
- Data Governance > Third-party systems > ELT components > CombinedSQL components
- Data Quality and Preparation > Third-party systems > ELT components > CombinedSQL components
- Design and Development > Third-party systems > ELT components > CombinedSQL components
Procedure
-
In the design workspace, select tCombinedSQLInput and click the Component tab to access the configuration panel.
-
Enter the source table name, in this case employees in
the Table field.
-
In the Schema field, select Repository from the list and click the [...] button right to the empty field to load the
schema you saved.while configuring the settings for tFixedFlowInput.
-
In the Repository Content window, expand
Generic schemas and select your
schema.
-
Click the [...] button right to Edit schema.
-
Select View schema, and in the first column
of the table, clear the check boxes for first_name,
last_name and city.