tfilterrow help to build criteria null values and records past certain dates

[Anonymous]

I'm trying to filter so we are only including rows where in a column there's null values and in another column we are only loading past a certain date. so far I have this but getting an error:

Currently in advanced mode in tfilterrow: 

Relational.ISNULL(input_row.EVENT_ID)==true && (input_row.SERVICE_DT>=TalendDate.parseDate("dd-MM-yyyy","01-07-2017"))

error:

[Anonymous]

Hi,

   Please remove ==true from the condition. You do not have to check the boolean value in a if condition. It will be automatically checked.

Similarly, you need to use the date difference function or compareDate function to compare dates

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

[Anonymous]

Thanks nikhilthampi can you help me with how the date should work? 

I tried this:

Relational.ISNULL(input_row.EVENT_ID) && TalendDate.compareDate(input_row.SERVICE_DT,(TalendDate.parseDate("dd-MM-yyyy","01-07-2017")),>="01-07-2017")

still got this error: 

[Anonymous]

Hi,

   You are not using compare date function according to its syntax. Please refer the tMap documentation for this function. It will compare two dates and give the results as a number. You need to compare that number to check whether first date is greater than second date. You need to remove the >= symbol in your syntax. There are lot of examples for about the usage of this function in Talend community.

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