Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Big Filter - Hopefully Simple?
Started 1 month, 1 week ago by roco
Just looking to apply a big filter to a transformed set of rows using 200 different filter strings(OR conditions). Seems a bit cumbersome to add 200 "OR" conditions in the Filter Step so I was hoping that the Step would accept comma separated values or something like that? Is there a better way? Thank you. Oh also, how do I also set the filter to be Case Insensitive?
Site: Pentaho Community Forums  Pentaho Community Forums - site profile
Forum: Data Integration / ETL  Data Integration / ETL - forum profile
Total authors: 4 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: pentaho.org

Other posts in this thread:

fabianS replied 1 month, 1 week ago
You COULD use the IN LIST filter type. Just write your list with semi-colon as separator. However this might be slow. Use the Stream Lookup and filter after that - this might be faster.
Size: 192 bytes
Customize:  Customize "<b>Reply 1</b>: Big Filter - Hopefully Simple? :: Data Integration / ETL :: Pentaho Community Forums"

roco replied 1 month, 1 week ago
Thank you FabianS. They both sound like good solutions. Can you enlighten me how to make the filter case insensitive?
Size: 119 bytes
Customize:  Customize "<b>Reply 2</b>: Big Filter - Hopefully Simple? :: Data Integration / ETL :: Pentaho Community Forums"

 

Top contributing authors

Name
Posts
roco
2
user's latest post:
Big Filter - Hopefully Simple?
Published (2009-11-10 09:37:00)
Thank you FabianS. They both sound like good solutions. Can you enlighten me how to make the filter case insensitive?
roco roco is offline Senior Member
2
user's latest post:
Big Filter - Hopefully Simple?
Published (2009-11-10 09:37:00)
Thank you FabianS. They both sound like good solutions. Can you enlighten me how to make the filter case insensitive?
fabianS
1
user's latest post:
Big Filter - Hopefully Simple?
Published (2009-11-10 03:47:00)
You COULD use the IN LIST filter type. Just write your list with semi-colon as separator. However this might be slow. Use the Stream Lookup and filter after that - this might be faster.
fabianS fabianS is offline...
1
user's latest post:
Big Filter - Hopefully Simple?
Published (2009-11-10 03:47:00)
You COULD use the IN LIST filter type. Just write your list with semi-colon as separator. However this might be slow. Use the Stream Lookup and filter after that - this might be faster.

Related threads on other sites:

Http://commons.ucalgary.ca/... format a feed's display...  Twitter / MYFD09 - site profile MYFD09 - forum profile Http://commons.ucalgary.ca/... format a feed's display http://re.rephrase.net/filter/ a simple RSS filter 5:47 AM Mar 3rd from web
Http://commons.ucalgary.ca/... format a feed's display http://re.rephrase.net/filter/ a simple RSS filter 5:47 AM Mar 3rd from web
Big weekend. Big plans. Big amp. Big dresser. Big bed...  Twitter / AlexFWord - site profile Alex Peters - forum profile Big weekend. Big plans. Big amp. Big dresser. Big bed (hopefully.) Even the little bed wants to be the big bed. Thanks Anthony Hopkins. 12:18 AM Oct 2nd from web
Big weekend. Big plans. Big amp. Big dresser. Big bed (hopefully.) Even the little bed wants to be the big bed. Thanks Anthony Hopkins. 12:18 AM Oct 2nd from web
[post] Cerberus Call Filter – Cheap & Simple Call...  Twitter / Berryreview - site profile Berryreview - forum profile [post] Cerberus Call Filter – Cheap & Simple Call Filter For Your BlackBerry: We have had call filters for.. http://tinyurl.com/9nw5m5 7:16 AM Dec 22nd, 2008 from twitterfeed
[post] Cerberus Call Filter – Cheap & Simple Call Filter For Your BlackBerry: We have had call filters for.. http://tinyurl.com/9nw5m5 7:16 AM Dec 22nd, 2008 from twitterfeed
BGilbert: A big filter, a big filter.  www.turbodieselregister.com - site profile 1st Generation Ram Forum (1989 - 1993) - forum profile BGilbert: A big filter, a big filter.
BGilbert: A big filter, a big filter.
I'm looking for some (hopefully) simple (hopefully) HTML...  AnandTech - site profile Software - Apps, Programming and Games - forum profile I'm looking for some (hopefully) simple (hopefully) HTML code
I'm looking for some (hopefully) simple (hopefully) HTML code
Simple Question, hopefully simple answer  Small Business Server Support Forum - site profile Remote Access - forum profile Simple Question, hopefully simple answer
Simple Question, hopefully simple answer
Thread profile page for "Big Filter - Hopefully Simple?" on http://www.pentaho.org. This report page is a snippet summary view from a single thread "Big Filter - Hopefully Simple?", located on the Message Board at http://www.pentaho.org. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity