I wanted to create a new variable which sets a flag based on data in another column. I used a custom Column Transformation workflow (Data Wizard) with an IF statement:
IF Column A > X OR blank, THEN return "1", ELSE "0"
In Phoenix the syntax is
if((A>2) | IsNull(A), 1, 0)
However Phoenix only executes the first condition, (A>2) in this case.
I had to do 3 consecutive Column Transformations to obtain the desired result:
The first two create intermediate result columns and each executes one condition, the third one combines the 2 intermediate columns into the final one. I heard from Simon that this is fixed in version 1.4, i.e. the operators should work.
I attach a very simple example which shows the principle.
This may be useful if you intend to flag e.g. AUCinf values from NCA where the extrapolated part exceeds 20% and you have to provide your results in the long thin format (NCA Final Parameters structure). You can't do that immediately on the Final Parameters worksheet, you first have to filter the pivoted worksheet using the condition (e.g. >20%) and then Append (you may have to append one of the filtered worksheets twice, once including the columns where the conditions applies and once without). Then you apply the Column Transformations and stack the final worksheet omitting the intermediate results.