Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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,
Labels (2)
6 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

"yes".equals(row1.flag) is another option 0683p000009MACn.png
I prefer this way, because it avoids an exception if row1.flag was null 0683p000009MACn.png
Regards,
Olivier
Anonymous
Not applicable
Author

Thanks to all
Anonymous
Not applicable
Author

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