Cannot access tags from worksheet in datalab

[Filip L]

Dear all, 

I cannot grap a tag from a worksheet. (seeq-spy: 193.17).

Any advise as well as some suggestions on how to add an existing PIMS tag to 1 of the existing dashboards?

Many thanks

Filip

[John Cox]

Hello Filip,

Please try this code approach instead:

[Filip L]

Thanks John that worked. An additional question. How can I add / append a variable to the list to be displayed? The suggestion by the AI assistant does not work apparently.

 

[John Cox]

Hello Filip,

Please look at this example: the pd.concat() approach worked for me to combine the dataframes. Please also note that in the resulting dataframe there are additional columns on the far right you will want to remove, as they don't apply to the original worksheet.display_items. Also, of course, you will want to assign values for the Color, Line Style, etc for the appended tag. 

 

Also, if you haven't looked at this SPy Documentation folder example already, here is a great example of manipulating worksheets (and specifically adding a new tag to an existing worksheet). This example is from the spy.workbooks in the SPy Documentation folder (located in every Data Lab project). 

[Filip L]

Many thanks, that worked!