Skip to main content

developerWorks >  Lotus  >  Forums  >  Lotus ActiveInsight and WebSphere Dashboard Framework  >  developerWorks

Filter rows based on the value using transform filter builder    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 2 - Pages: 1 - Last Post: Nov 23, 2009 11:35 AM Last Post By: Hyderap Threads: [ Previous | Next ]
Hyderap

Posts: 6
Registered: Nov 03, 2009 02:49:57 PM
Filter rows based on the value using transform filter builder
Posted: Nov 03, 2009 03:08:54 PM
 
Click to report abuse...   Click to reply to this thread Reply
Attachment YearStatus.zip (3.2 KB)
Can anyone help me in figuring out how to filter rows based on the value in a column. I was succesfull partially using Transform-filter builder. Able to remove specified value but not the complete row. Please find attached zip file which containd both the model and excel sheet I used. Thanks.
Hyderap

Posts: 6
Registered: Nov 03, 2009 02:49:57 PM
Re: Filter rows based on the value using transform filter builder
Posted: Nov 04, 2009 11:47:48 AM   in response to: Hyderap in response to: Hyderap's post
 
Click to report abuse...   Click to reply to this thread Reply
By changing Element to Filter value in Transorm-Filter from ExcelContent/Row/Status to ExcelContent/Row, it worked fine.
But I found another issue, I have to first click Wholedata service and then WithoutRed to see the output withour Red row. If I click WithoutRed service first I still see complete data..any idea.. Thanks.
Hyderap

Posts: 6
Registered: Nov 03, 2009 02:49:57 PM
Re: Filter rows based on the value using transform filter builder
Posted: Nov 23, 2009 11:35:57 AM   in response to: Hyderap in response to: Hyderap's post
 
Click to report abuse...   Click to reply to this thread Reply
Created 2 provider models one for whole data and for without red, instead of having both the operations in same model. It's working fine now.

Point your RSS reader here for a feed of the latest messages in all forums