How to get the dervations column to populate

Derivations column

Hi Debora,

If you contact me personally, I can provide you more details about how to do this.
Did you also inspect the XML that is generated, i.e. not only look what the browser shows you? I ask as your statement "COMMENTS/DERIVATIONS column in the define" does not make sense: there are no columns in the define.xml, only in the view that is generated by the stylesheet in the browser.
In many cases like this, editing the generated define.xml using an XML editor (also NotePad++ is very good) allows to resolve the issue.

Contacting you.

Hi Jozef:

Thanks for the reply...I will gladly contact you personally! Can you tell me how exactly to do that? I clicked on your username, but there is no e-mail link.

I appreciate your quick response!

Debora.

Derivation / Comment

Also, there is a difference between a comment and a derivation. They may display in the same column, but they are different metadata elements. Derived variables need to have a derivation. They may also have a comment, but the derivation is required for derived variables.

 

Derivations "column"

Hi Debora, I am not allowed to post my mail address here, but if you do a 1 minute Google search on "XML4Pharma", you will find my contact data very easily.

I am probably using the wrong terminology....

When I say "Comment/Derivation" I am talking about the header in the last column of the define.xml where the individual data sets are described. In the EXCEL file, VARIABLES tab, I populate the COMMENTS column and was expecting the contents of that column to populate the "Comment/Derivation" column in the define. In the XML code itself, I see the text, it just doesn't display in the define.

Variables.Comment = Comments.ID

Hi Debora, 

Unfortunately, it does not work this way.

In Variables tab, a Comment column includes a reference to info into Comments tab rather than an actual comment:

Variables.Comment = Comments.ID

Comment text is stored in Comments.Description.

Please remember, that XML is a case-sensitive language. So, IDs values in Variables.Comment and Comments.ID should be identical. For example, 'ARM' is not the same as 'Arm' or 'ARM '.

Regards, 

Sergiy