topic Re: Filter Source Data based on Conditions- Component Suggestion? in Talend Studio

Filter Source Data based on Conditions- Component Suggestion?

desanip — Fri, 01 Nov 2019 14:42:13 GMT

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?

Re: Filter Source Data based on Conditions- Component Suggestion?

TRF — Fri, 01 Nov 2019 19:19:54 GMT

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

Re: Filter Source Data based on Conditions- Component Suggestion?

Anonymous — Fri, 01 Nov 2019 19:21:28 GMT

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