How do I get just the records I need?

[cooneyj]

I am very new to Biztalk - I'm sorry if this is a simple question. I have two fields Type and Order-field coming in. Depending on the Type I need the Type and it's Order-field mapped to two areas (one area gets four of the Types, the other gets the other five or six). I've tried to do this with C# and a switch but I am getting all the data into one area and it gives me an error for any of the Types that don't match in that area.
I've looked at trying to do this with the Value Mapped Functoid along with the Equal Functoid but it would be crazy with the all that. Does this make sense?

[M1kkelZU]

If you're talking about a sort of filter, I'd recommend reading this:

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/064372d5-d97c-4b3e-97e9-994be7d557ba/

http://stackoverflow.com/questions/12746724/sql-server-select-statement-filter-by-passed-in-string-array

There are loads more examples, but I only copied 2 as I'm not sure if you are using SQL.