Data manipulation

Is there a best way to filter or clean data either in rows or columns based on multiple conditions. Attached is sample data set I need to clean based on as of date (Eg: 04/02/2016). I need to keep data for registered weeks that are fully complete and truncate any data in reg data column for partially completed and not completed weeks if any exists. 

 

Please suggest. Thank you in advance

can someone please help me with a suggestion

Dear kyadla,

this question is difficult to answer because it is very general....

Did you take a look into the different Row Filter nodes (You can search for Row Filter using the Fuzzy Search)

With the rule-based Row Filter you can enter individual rules.

Best, Iris