Inside the Data Wizard, there are 3 different types of filters that can be used to include/exclude data:
Built In
Selection (exclude)
Custom (include)
While the Built In and Selection options are useful for single selections, often you want to make a complex inclusion/exclusion. That is when you need the Custom filter. For example, perhaps you want to exclude all Day 3 data from Cohort 1, but retain the Day 3 data from Cohort 2. Assume we have concentration time data with descriptors for Cohort (1 or 2) and Day (1 or 3).
Open a Custom Filter and enter the following:
(Cohort=2) or (Cohort=1 and Day=1)
Using that filter will include all data with Cohort = 2, and only Day 1 data from Cohort 1.
Another example includes handling BLQ data. Perhaps your laboratory sent the data with all BLQ values set to 0 and you want to remove all post-dose zero values so that you can perform model fitting. However, you want to retain zero values at the early time points (e.g. pre-dose and prior to the first observed concentration). You could use a Custom Filter like the following:
Time <2 or (Time >=2 and Conc > 0)
Using that filter will include all data with times less than 2 hours, and then all data with times greater than or equal to 2 with non-zero concentrations.
You can build these Custom filters as complex as you need to subset the data with a single command. Be sure to check out the Filtered Rows Worksheet to see if you separated the data correctly.
Let’s assume that you want to exclude any rows that have the word ‘Placebo’ within a Treatment column but there are several entries like ‘Placebo_P1’ and "Placebo_P2’. Instead of fitering twice you can accomplish this with a custom(include) statement.
The custom(include) is within the filter (Data Wizard>Action Filter for PHX 1.3 or Filter Worksheets in
Not(Treatment like’%Placebo%')
Note that the custom option is always an ‘include’ so the ‘Not’ at the beginning indicates to do the opposite.
Sorry Raghav, I don’t understand the question, can you make a project of your dataset and tell us more clearly what you want removed, I think you want just the first row of data, it might be easier to simply select e.g. time=0
however if there are different times then perhaps use the UniqueValues sheet from Split worksheet.
Please note that a screen shot is much easier to understand, better yet a project since the pasted values above were not formatted as I would expect
