tMap filter is not working

[Anonymous]

Hi,

I have tMap component for the XML extract. For some of the column/attribute filter works fine but for one of the column/attribute it is not.

Below is the filter condition.

row2.timeStamp.equals("2017-07-06T06:35:00.000000")

Could you please let me know if any issue?

[Anonymous]

What is the data type for the row2.timestamp in talend?

[Anonymous]

Hi, Data type is string. Originally it is on date on XML but due to parsing issue, I had to change it to string.

[Anonymous]

Expression is fine. Can you verify incoming data?

[Anonymous]

This is definitely because your timestamp column does not hold "2017-07-06T06:35:00.000000". You need to use a tLogRow to see what the column actually holds. The tMap filtering is not broken, your filter is not matching the data it is filtering.

[Anonymous]

I found an alternative solution to this

[Anonymous]

Hi Brawal,

Please share the solution in the forum, then it will be helpful for others too..

Thanks.