Hello all, trying to resolve an issue with a simple data wizard manipulation and wondering if I could get some feedback.
Basically I am trying to perform the following operation: For all times points corresponding with each subject involved in the study, I would like to replace the concentration values where time is not equal to 0 with the corresponding time point that is associated with time=0 for the same subject.
I’ve tried using an If + substitute statement, but I’m not sure how to substitute the value with a new one which corresponds to a different value in another cell, especially when it changes for every subject.
Is there any way to have a custom transformation which would perform this operation?
Thanks in advance,
Joseph
Sorry I don’t quite understand what you’re asking. Are you saying you want the value at time 0 to be assigned to all time points. by subject. I think this would be easier with a filter and merge.
Can you provide a dataset that includes a desired result column ? it doesn’t have to be super large, a few profiles should do the trick and help development/testing.
Simon
Hi Simon, here’s a table representation of the data transformation i’m trying to perform:
What would be the fastest way to apply a data wizard to achieve the desired replacement concentration is my question
example.xlsx (8.77 KB)
please attach as CSV or excel. Also note what I ma saying that DW might not be the best tool to achieve what you are asking.
Hello Joseph,
There are several ways to accomplish this. In the attached project I show 3 ways of getting what you want. There is a way to use a single datawizard (Option1) that requires 4 steps. Option 2 and Option 3 first filter out time=0 row and then they merge or crossproduct with the original dataset. The project was created in Phoenix 8.1. If you don’t have access to it, I have included a picture of the data wizard summary for you to recreate.
Hope this helps,
Ana
Test.phxproj (453 KB)
