How to Rename Field Names for Easier Data Identification

por Janet Albers | Actualizado: 11/11/2015 | Comentarios: 0

Temas Blog


Buscar en el Blog


Suscribirse al Blog

Configure sus preferencias para la recepción de notificaciones por email cuando se publiquen nuevos artículos en el blog que coincidan con sus áreas de interés.


Entre su dirección email:



Sugerir un Artículo

¿Hay algún tema sobre el cual desea saber más? Háganoslo saber. Por favor sea lo más específico que pueda.

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 datalogger 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.


Compartir este artículo


Acerca del autor

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.

Ver todos los artículos de este autor.


Comentarios

Please log in or register to comment.