TIP: Using DataWizard on Columns with Special Characters

Phoenix Certara Forums Phoenix WNL basics
1

Outputs from NCA objects contain a few column names that are difficult to work with downstream due to special characters. For example, user might want to filer data where the AUC_%Extrap_obs is greater than a percentage. Below and in the attached project are some tips how to work with columns with special characters:

  1. When using Data Wizard > Filter > Include, place brackets around the column name.

[AUC_%Extrap_obs]<30

  1. When using Data Wizard > Transformation > Custom, write equations without special characters and map them to the columns with special characters.

if(AUC_Extrap_obs>30,“”, AUCINF_obs)

The attached project shows some of these tips.

NCA and DataWizard.phxproj (426 KB)