Hi,
I'm looking at using the Switch activity. I have specified the column to select on but, in the cases section, the documentation just talks about having exact matches. The kind of thing that I want to do is say if the value > 100 then put onto output link 1, > 200 put onto output link2, otherwise reject.
Likewise, I'd like to do a string insensitive search as well (like an oracle LIKE %AAA%), i.e. if string contains AAA then put onto link 1, BBB onto link 2 and others onto reject.
At the moment it looks like I'd have to define a case for every case, e.g.
1=0
2
3
4
5
...
99
100=1
101
102
103
... etc
which would get quite painful over many numbers.
Does anyone know if this can be done?
Many thanks,
Dave
Switch Activity - specifying ranges
Moderators: chulett, rschirm, roy
I thought the transformer just manipulated data and pushed the new data onto the output link. I didn't know there was selection. What I want is the inverse of the funnel, i.e. a selective demultiplexer. No transformation of data. The same data will go one whichever link is selected.
How would the transformer do this?
Many thanks.
How would the transformer do this?
Many thanks.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Switch Activity - specifying ranges
Try using FILTER stage where you can specify < or > etc. You can specify the same as CONSTRAINTS in transformer stage.