How to Rename Field Names for Easier Data Identification

by Janet Albers | Updated: 11/11/2015 | Comments: 0

Search the Blog


Subscribe to the Blog

Set up your preferences for receiving email notifications when new blog articles are posted that match your areas of interest.


Area / Application

Product Category

Activity

Corporate / News

Enter your email address:



Suggest an Article

Is there a topic you would like to learn more about? Let us know. Please be as specific as possible.

Leave this field empty

spreadsheet with column headings

When you view your measurement data in tabular format, such as in View Pro or similar software, are your column headings, or field names, helpful to you? At a glance, do your field names quickly identify the data in the columns? If not, you may be relieved to know that you can change the default field names to something more recognizable.

By default, the data logger automatically assigns a name to each field, or column, in a table. These field names are a combination of the variable name (or alias if one is defined) and a three-letter mnemonic for the processing instruction that outputs the data. For example: batt_volt_Min is likely the minimum battery voltage.

For some output instructions, the field names can be a bit more arcane, but you can easily overwrite them.

  1. The WindVector() instruction outputs a maximum of four fields, or columns, resulting in field names such as WindSpeed_Wvc(1) and WindSpeed_Wvc(2), as shown in the left circle below.
  2. It is helpful to overwrite those default field names with names like WV_WindSpeed and WV_WindDir, as shown in the right circle below.

arcane column headings

To change the default field name, use the FieldNames() instruction. The FieldNames() instruction must immediately follow the output processing instruction that has the default field name you want to overwrite.

Tip: You can see the field names that have been defined for each data table in your program. After you save your program in the CRBasic Editor, navigate to Tools | Show Tables.

Show Tables menu item with defined field names


I hope this information helps you identify your data for easier analysis and sharing. If you have any comments or questions, feel free to post them below.


Share This Article


About the Author

janet albers Janet Albers is a Senior Technical Writer. She'll share tips, simplify concepts, and guide you to a successful project. She's been at Campbell Scientific, Inc. longer than the CR1000, but not quite as long as the CR10X. After work hours, Janet enjoys the outdoors with her boys and dogs.

View all articles by this author.


Comments

Please log in or register to comment.

We're active on social media!
Stay informed with our latest updates by following us on these platforms: