If you're talking straight rss feeds, its probably just easier to write it in code. But Yahoo Pipes is more a GUI tool than a coding solution, so I'm making the assumption you don't want to code this yourself. In that case, check out Dapper or Kapow! Technologies. There are others, but those are probably the best.
It's unfortunate that these products aren't better integrated. YQL is more reliable (especially lately) and can do more things, but Yahoo Pipes is very nice for what it does, and some simple things in Pipes require some work in YQL. Why are these completely separate products anyway?
http://stackoverflow.com/questions/2627387/is-there-a-decent...
http://stackoverflow.com/questions/2019887/alternatives-to-y...
Personally, I think pipe2py looks interesting.