Topic
2 replies Latest Post - ‏2009-11-23T16:35:57Z by Hyderap
Hyderap
Hyderap
7 Posts
ACCEPTED ANSWER

Pinned topic Filter rows based on the value using transform filter builder

‏2009-11-03T20:08:54Z |
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.
Updated on 2009-11-23T16:35:57Z at 2009-11-23T16:35:57Z by Hyderap
  • Hyderap
    Hyderap
    7 Posts
    ACCEPTED ANSWER

    Re: Filter rows based on the value using transform filter builder

    ‏2009-11-04T16:47:48Z  in response to Hyderap
    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
      Hyderap
      7 Posts
      ACCEPTED ANSWER

      Re: Filter rows based on the value using transform filter builder

      ‏2009-11-23T16:35:57Z  in response to Hyderap
      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.