Hi,
I am doing a meta review of data and I am serially importing the same excel workbook into Phoenix to add another tab to my project. Is there a way of reimporting data without generating a separate file heading with a number appended?
If I update values or something I would like to just reimport the workbook and overwrite what is there or have the option to add another tab.
Is that possible?
Thanks in advance
In Phoenix WinNonlin it will create new worksheets as you are seeing, however what i would do is set up your workflow to have datalinks e.g https://support.certara.com/forums/topic/1588-new-worksheet-to-a-locked-workflow/?p=6925
then after you have imported sheet “xxx_1” then simply replace the original “xxx” mapped to the datalink with the latest data.
If you need to combine several of these imported worksheets use append in Phoenix and then map its results to the data link. Is that helpful?
Simon
PS (if you use Integral to upload new versions of a worksheet it would replace that for you and you would also have access to a comparison tool to show differences;
Simon.
