Get Empowered: Tip #248 | Column Libraries
Tip #248: How to Create a Column Library
In this week’s tip, we will learn how to create a column library.
Some time ago, I was asked if there is a way to create a list of columns, that when you select the column part number in either the Sample Set Method or Alter Sample, other fields such as particle size, length and so forth would be automatically populated. It can be done with Custom Fields. This example includes particle size, column length and column internal diameter. You could add additional fields such as particle type, carbon load and so forth.
Let’s get started.
The first Custom Field would be for the catalogue of columns. This is a Field Type ‘Sample’, Data Type ‘Enumerated’. Enter the Column Part Numbers in the ‘Translation Definition’ table (figure 1).
The next Custom Field is for the corresponding particle sizes. Once again, this is a Field Type ‘Sample’, Data Type ‘Enumerated’. Enter the ‘Particle Size Values’ in the Translation Definition table (figure 2).
The next Custom Field is for the corresponding column lengths. Once again this is a Field Type ‘Sample, Data Type ‘Enumerated’. Enter the ‘Column Length Values’ in the Translation Definition table (figure 3).
The last Custom Field is for the corresponding internal diameter. Once again this is a Field Type ‘Sample’, Data Type, ‘Enumerated’. Enter the ‘Internal Diameter Values’ in the Translation Definition table (figure 4).
View the new Custom Fields in the Sample Set (figure 5).
Click in the ‘Column_PN’ field and select a column part number (figure 6).
The remaining Custom Fields automatically populate with the corresponding values (figure 7).
It’s that easy!
Final Note: This can be done with either the Pro or QuickStart interface.
Please rate this Empower Tip of the Week
Next time in Empower Tip #249 – I will answer another Empower CDS user question about printing calibration curves from the Curves tab in the project window.
JOIN US for an Empower: Ask Me Anything Webinar on November 16, 2021
Neil will answer your questions about streamlining your Polymer Workflow using the Empower GPC Option.
JOIN US at [inform] 2022 | May 9-12, 2022 · Nashville, TN USA
Join the Waters Informatics community to discuss the latest forward-thinking digital innovations and technologies to elevate quality and improve laboratory effectiveness.
More Empower Resources:
- Get the latest Empower projects, options, and more. Check out the New Waters Marketplace.
- Want to learn more? Check out our Empower training courses and eLearning.
- Minimize your lab downtime and protect your business against potentially expensive disruptions with the Empower Enterprise Software Extended Critical Support Plan with 24 x 7 x 365 coverage – Learn more
- Build your technical skills and professional network. Share, ask, and interact with peers from around the globe in dynamic discussions by joining our Informatics Community Forum.
Do you want Empower Tips sent to your inbox every week?
Questions? Tips of your own? Let us know!