Filter Source Data based on Conditions- Component Suggestion?

[desanip]

Hello,

I have a database table/ file and i want to extract the data from it and apply conditions on the source data/file like age>20, date>1980, reject a column if its not a String type and so on.. What is the best component to use here? TMAP? I also read about TschemaCompliance in Talend? Can anyone suggest how i should approach this? anyone has an example?

[TRF]

tSchemaCompliance is to check records are aligned on the defined schema.
For your question, use tFilterRow or tMap.

[Anonymous]

Hi,

    You can use a tSchemaComplianceCheck component to verify whether the data is with right data types. For the conditional checks, I personally handle the filter clauses and expression areas of tMap component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved