topic Re: tMap filter is not working in Talend Studio

tMap filter is not working

Anonymous — Thu, 09 Nov 2017 17:21:26 GMT

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?

Re: tMap filter is not working

Anonymous — Fri, 10 Nov 2017 00:48:22 GMT

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

Re: tMap filter is not working

Anonymous — Fri, 10 Nov 2017 00:51:25 GMT

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

Re: tMap filter is not working

Anonymous — Mon, 13 Nov 2017 16:33:20 GMT

Expression is fine. Can you verify incoming data?

Re: tMap filter is not working

Anonymous — Mon, 13 Nov 2017 23:56:14 GMT

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.

Re: tMap filter is not working

Anonymous — Tue, 14 Nov 2017 21:29:36 GMT

I found an alternative solution to this

Re: tMap filter is not working

Anonymous — Wed, 15 Nov 2017 10:17:41 GMT

Hi Brawal,

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

Thanks.