topic Re: [resolved] How to route data to different targets based on conditions in Talend Studio

[resolved] How to route data to different targets based on conditions

Anonymous — Sat, 16 Nov 2024 12:05:25 GMT

Hi,
Please let me know component name used to divide source data based on given conditions. For example if I have 10 ids in source so I want to route 5 ids to one flow and 5 to another flow based on filter conditions. Means how to route data to different flows based on given condition,
Thanks,

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Mon, 11 Mar 2013 07:12:29 GMT

Hi inabi,
U can use tMap component to route he data to different flows based on the conditions. On the target side , there is expression filter ( Activate/Unactivate Expression filter). U can give ur condition here on every target flow.

Hope this would be helpful to u.
Thnx,
Saty.

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Mon, 11 Mar 2013 07:55:19 GMT

I also tried it but not giving output as desired. Simply i am reading data from xml file in which i have field Flag and value (Yes or No). I want to load Yes records to one target and No to another target. In tMap component i am giving simple codition like
row1.flag=="Yes" for one target
row1.flag=="No" to another target
But none of the target is populated. Eventhough I have kept filter expression Activated.
Pls help.

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Mon, 11 Mar 2013 08:01:28 GMT

I also tried it but not giving output as desired. Simply i am reading data from xml file in which i have field Flag and value (Yes or No). I want to load Yes records to one target and No to another target. In tMap component i am giving simple codition like
row1.flag=="Yes" for one target
row1.flag=="No" to another target
But none of the target is populated. Eventhough I have kept filter expression Activated.
Pls help.

If the datatype is String, you should use the method row1.flag.equals("yes") instead of row1.flag=="Yes".
Shong

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Mon, 11 Mar 2013 15:02:27 GMT

"yes".equals(row1.flag) is another option
I prefer this way, because it avoids an exception if row1.flag was null
Regards,
Olivier

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Tue, 12 Mar 2013 07:52:09 GMT

Thanks to all

Re: [resolved] How to route data to different targets based on conditions

Anonymous — Thu, 26 Nov 2015 10:51:27 GMT

Hi all,will anybody tell me how can we get cumulative salary result