How to Rename Field Names for Easier Data Identification

de Janet Albers | Atualizada: 11/11/2015 | Comentários: 0

Pesquisar o Blog


Inscrever-se para o Blog

Receber e-mail quando um novo artigo é publicado. Escolha os temas de seu interesse.


Area / Application

Product Category

Activity

Corporate / News

Insira o seu endereço de email:



Sugerir um artigo

Existe um tópico que você gostaria de saber mais à respeito? Nos informe.

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.


Compartilhe este artigo


Sobre o 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.

Veja todos os artigos deste autor.


Comentários

Please log in or register to comment.