8. Data Browser and Channels¶
Answers to common questions about the Data Browser, the Data Editor, channel handling, merging data files and the File List window.
8.1. Time channels and sampling rates¶
8.1.1. How are channels with different sampling rates plotted over time?¶
Measurement files such as MDF or MF4 files contain several channel groups (rasters), and each group has its own time channel. A channel must be plotted against the time channel of its own group, otherwise the curves have different lengths or are shifted.
Click the Tree Structure button of the Data Browser toolbar to display the channels grouped by channel group (see Toolbar).
Switch on the automatic x-channel selection. When you select the y channel, UniPlot selects the time channel of the same group as x channel (see Automatic X-Channel Selection).
A time channel is recognised by the channel attribute
Type = "Time Channel". The attribute is created by the MDF import. If a time channel is not recognised, add the attribute manually: open the file with Edit, right-click the time channel and choose Add Attribute….
If the plot still shows channels with different durations, bring all channels onto one time base, see How can I bring all channels of a file onto one time channel (interpolation)?.
See also: The Data Browser Window, Import of MDF Files.
8.1.2. How can I bring all channels of a file onto one time channel (interpolation)?¶
Use the channel interpolation of the Data Browser:
In the Data Browser click Edit to open the data file in the Data Editor.
Right-click in the data grid and choose More Functions > Channel Interpolation….
Select the time channel, or define a new time channel with minimum, maximum and delta. Start the function. Remove channels that cause errors from the selection.
UniPlot creates a new NC file with the name of the original file followed by
_transand displays it in the Data Browser. All channels of this file share one time channel. You can plot them together or export them to one table (CSV).
You need this, for example, when a data table with channels of different sampling rates shows empty values in the second column, when plotting two channels with a different number of points gives wrong results, or when you want to export an MF4 file with one time channel per channel group to CSV.
The function does not extrapolate: values outside the measured time range are set to missing. Without interpolation, channels of different groups cannot be written to one CSV file. An Excel export creates one sheet for each group.
The interpolation is not applied automatically when you replace data with the data exchange. If you use a template with data exchange, first run an interpolation (for example with the UniScript function NC_Interpolation) to create a new data file. Then exchange the data of the template with this file. In an automated workflow you can do this with the The Sequencer.
See also: Browser=>Interpolation, NC_Interpolation, Automatic X-Channel Selection.
8.1.3. Why do formula channels not appear in Channel Interpolation, and why does Synchronize Data Files switch back to the original time channel?¶
Both behaviours are intentional.
Channel Interpolation lists only channels that have the attribute
Type = "Time Channel". If you calculate a time channel with a formula (for example seconds computed from a millisecond time channel), add this attribute to the formula channel: right-click the channel in the Data Editor and choose Add Attribute…. The channel then appears in the list.Synchronize Data Files selects the time channel that belongs to the chosen synchronization channel automatically (since R2023.1 for files with a defined time channel). This is useful for files with several rasters, so a manual selection of another time channel is reset. The time data must be in seconds. If the default time channel is in milliseconds, convert it to seconds first (for example with a formula channel or the Unit Converter) and use the converted channel.
See also: Browser=>Interpolation, File=>More File Functions=>Synchronize Data Files.
8.1.4. How do I move a signal to a different timeline group so that identical signals are not shifted?¶
If a project contains many time axes (timeline groups), signals with identical values can be displayed shifted against each other because they belong to different groups. There is no automatic function to unify them. You can change the group of a signal manually:
In the Data Browser click Edit.
Select the channel and, in the attribute list, select the attribute
_nc_group.Change its value to the name of the required timeline group (for example from
Seg1_1toSeg1), click Set and close the editor.
The signal now belongs to that group and can be plotted with the synchronised time. Repeat the steps for other signals. If the signals have different sampling rates, use the interpolation described in How can I bring all channels of a file onto one time channel (interpolation)? instead.
See also: The Data Editor.
8.1.5. How can I avoid ramps or interpolated values for a status or bit signal?¶
In the diagram: apply the filter step to the dataset (filter step - Step, see List of filter functions). UniPlot connects data points by straight lines, so a sporadically sampled status signal shows ramps. The filter draws horizontal lines between the samples instead, so the curve becomes stair-shaped.
In the data: the step filter only changes how the curve is drawn. It does not remove interpolated points that already exist in the data file, and it does not stop the channel interpolation (see How can I bring all channels of a file onto one time channel (interpolation)?) from creating intermediate values. To set the interpolation type for single channels:
Create a text file named
Bit_Channel_Interpolation.iniin your UniPlot user directory. You find the folder under User Home Directory in Tools > More Options.Add the section
[Interpolation]with one line per channel:<channel name> = <type>. The types are:1: previous sample value2: nearest sample value3: next sample value
Channels that are not listed are interpolated linearly. Lines that start with a semicolon (
;) are comments.
Example:
[Interpolation]
ShiftActive = 1
GearPos = 2
UniPlot reads the file each time Channel Interpolation… (Data Editor, More Functions), Synchronize Data Files or the UniScript function NC_Interpolation runs. Set the time increment of the new time channel smaller than the sampling interval of the signal. Otherwise samples are lost.
See also: Filter Functions for XY datasets, Browser=>Interpolation, NC_Interpolation.
8.2. Merging, splitting and combining data files¶
8.2.1. How can I combine several data files, or join them end to end into one continuous channel?¶
Use the Data Editor. Import the first file (File=>Import Data), click Edit in the Data Browser and right-click the data grid. Two commands are available:
Add Channels from File… adds the channels of a second file to the first file, for example to compare channels of several tests in one diagram. If the channels have different sampling rates, bring them to a common time base with the channel interpolation, see How can I bring all channels of a file onto one time channel (interpolation)?.
Add Data Records from File… appends the data records of one or more files to the active file (see Browser=>Add Files).
To join files end to end (for example one file per day):
Import the first file and click Edit in the Data Browser.
Right-click the data grid and choose Add Data Records from File….
Select all other files (multiple selection). If the files contain no marked time channel, select the time channel in the dialog.
Save the result, for example with Export in the editor. You can then plot it as one curve.
How the records are joined:
The files are appended in the order of the file list.
Channels are matched by name. The names must be identical, and upper/lower case matters. Data is only added if at least one channel name matches a channel of the active file. Channels that are missing in an added file are set to
missing.The time channel does not restart at 0 for each file. UniPlot adds the end time of the previous file plus one time step to the time of the next file. The result is one strictly increasing time channel.
Selecting several files in the import dialog only creates one NC2 file per selected file; it does not merge them.
In UniScript use NC_MergeFiles or NC_AddFiles. To synchronise two files from different data loggers before merging, see File=>More File Functions=>Synchronize Data Files.
See also: Browser=>Add Files, NC_AddFiles, NC_MergeFiles.
8.2.2. How can I split a measurement file into several files based on a channel value (for example engine speed)?¶
Use the classification of the Data Browser:
Open the file in the Data Browser, click Edit and choose Browser=>Classify from the shortcut menu. Select the channel (for example the speed) and specify the tolerance as an absolute value.
UniPlot creates a new channel
_index_<channel name>(for example_index_EngSpd) that contains the class number of each record, starting with 1.Use the index channel to split the file into one file per index value with the command More Functions > Classes: Split in Files….
In UniScript the same grouping is available with NC_Classify. The index channel can also be used for datasets of the type 2D: x/y/Cycle-Index.
See also: Browser=>Classify, NC_Classify.
8.2.3. How can I plot only selected rows of an Excel sheet or data table?¶
There is no direct option for this. Use a record filter:
Import the file and open it in the Data Browser.
If the file has no suitable reference channel, add a counter channel with Add Channel in the Data Editor (see The Data Editor).
Define a record filter on this channel (for example on the counter values of the rows you want) and plot the filtered data (context menu command Apply Record Filter, see Context Menu).
A template saves the data of the filtered selection together with the filter condition.
See also: The Data Browser Window.
8.3. Editing channels, attributes and records¶
8.3.1. How do I delete a channel or records from a data file?¶
Open the file with Edit in the Data Browser and use the shortcut menu of the data grid (see The Shortcut Menu):
Channels: select the channel(s) by clicking the channel name button, right-click and choose Remove Channels (shortcut Ctrl+DEL). Alternatively choose Mark Channels As Deleted first and later Remove All Marked Cells.
Records (rows): select the rows by clicking the record number buttons (hold Shift to select a range), right-click and choose Remove Records. Alternatively choose Mark Records As Deleted and then Remove All Marked Cells.
Removing channels or records cannot be undone. As long as data is only marked as deleted, UniPlot ignores the delete flag, for example when you load a dataset. To undo a mark, choose Remove Delete Flag.
See also: The Data Editor.
8.3.2. With a record filter in the Data Editor, deleting the marked rows deletes other rows. Why?¶
Fixed in R2026.1
This was a bug in the Data Editor. Update to R2026.1 or later.
R2026.0: if you had never toggled the option Show only filter results in the Data Editor, deleting rows in filtering mode used the row numbers of the unfiltered data. The first rows of the file were deleted instead of the marked filtered rows.
Up to R2022.5: with a record filter active and the unfiltered results displayed, deleting a row marked the wrong row for deletion. Deleting a row could also break the filtered view. This was fixed in R2022.6.
Workarounds for older releases:
R2026.0: in the Data Editor switch Show only filter results off and on once, then delete the rows.
Any older release: define the filter so that it selects the rows you want to delete. Choose the shortcut menu command More Functions > Mark Filtered Records As Deleted (red). Switch off the filter: the correct data points are now marked. Remove them with Remove All Marked Cells.
Check the result before you save the file. If wrong rows were deleted, close the file without saving.
See also: The Data Editor, The Shortcut Menu.
8.3.3. Why is the Filter option greyed out in the Data Editor for a particular file?¶
Record filtering requires all channels of the file to have the same size. It is therefore not available for files that contain channels with only a single data point, for example a recorder time or a version name channel. Open the file with Edit, delete these single-point channels (Remove Channels), close the editor and open it again. The filter is available again.
Do not mix channels with a single value (scalar or root data) and channels with many values in one table when you filter: after filtering to one row the scalar channels can become empty. Keep scalar root data and vector channels in separate tables.
See also: The Data Editor.
8.3.5. The offset (add_offset) and scale factor of a channel have no effect or the offset field is missing. What can I do?¶
Switch on the display of scaled data. UniPlot applies the channel attributes add_offset and scale_factor only with this setting:
In the Data Browser click Edit and open the configuration dialog (Browser=>Options).
Enable Display data scaled (Eval attributes ‘add_offset’ and ‘scale_factor’) and confirm with OK.
To add an offset, for example to convert degrees Celsius to Kelvin:
Select the channel in the Data Editor.
Choose the attribute
add_offset, enter the value and click Set.Plot the data again.
The offset is stored in the channel attributes. If you replace the data of a dataset with data from another file or sheet, the attributes of the new data apply. The attributes are described in Standard Attributes.
See also: Browser=>Options, Standard Attributes.
8.3.6. Why does UniPlot rename channels with dots or other special characters (n_t_mv becomes n_t_mv_)?¶
By default UniPlot replaces special characters in channel names (. - + $ # ~ ! ^ & %) by an underscore during import, because the channel name is also used in formulas and scripts.
To keep the characters, enable Allow Special chars in channel names in Tools > More Options > Data Import and Data Browser (see Data Import and Data Browser) and import the file again. Keeping the option switched off is recommended, because such names cannot be used everywhere.
To display the original text, use the channel attribute
title.
See also: netCDF-SDK, Data Import and Data Browser.
8.3.7. How do I create a new formula channel? The Formula List is empty and does not open¶
If the formula folder does not contain a formula, UniPlot shows the message Formula List is empty and no window opens, because the list has no commands to create or duplicate a formula. To create a formula you need at least one formula definition. Create a formula channel in the Data Editor with Add/Edit Formula Channel… (see The Add/Edit Formula Channel Dialog Box) or copy an existing formula file and rename the formula variable inside it.
A new formula may not be shown in the Data Browser immediately. Updating the formula list (Tools=>Update Formulalist) or pressing F9 does not always help. Re-import the file, or open the Data Editor with Edit and close it again.
See also: Formula Interpreter 1 - Introduction, Defining Formulas.
8.3.8. How can I show, list or export channel or global attributes, for example the Comment or TDM file properties?¶
The Data Browser has no command that exports the attributes of all channels to a text or Excel file. Use one of these options:
All attributes of a file as text: run the tool ncdump.exe from the UniPlot program folder in a command prompt, for example
ncdump -h measurement.nc2 > measurement.txt. The option-hwrites only the header: all channels with all their attributes (title,units,Comment, …) and the global attributes, without data. Open the text file in an editor or in Excel.View the attributes of one file: open it with Edit in the Data Browser. The Data Editor also lists the global attributes (see Global Attributes).
One attribute on a page: use the field function @f{ncattfromdata} in a text object or table cell (see Text Placeholder and Field Functions).
A list of one attribute for all channels: write a short UniScript loop with nc_varinq_name and nc_attget (or NC_GetVarAttribs) and write the result to a table, an Excel file or a text file.
The properties of a TDM/TDMS file (for example a serial number) are imported as global attributes of the NC file. They are available as placeholders on a page or in a text box (see Import/Export of TDM Files). If a property is not listed, check the global attributes of the imported file in the editor.
See also: Overview Field Functions, ncdump.exe.
8.3.9. Why are 1.35 and 1.45 both displayed as 1.4 when I reduce the number of decimals?¶
This is only a display effect. Many decimal values such as 1.35 and 1.45 cannot be stored exactly as binary floating-point numbers. The stored value of 1.35 is slightly above the half value and the stored value of 1.45 slightly below it, so both are rounded to 1.4. Other programming languages such as Python behave the same way.
The value itself is not changed. Sums, means and other calculations always use the exact value; only the number displayed in the table is rounded. The behaviour is defined by the underlying number conversion and cannot be changed. To display more digits, increase the number of decimal places, see Browser=>Options (Decimal Places).
8.4. Limits and unexpected behaviour¶
8.4.1. What is the maximum number of channels in a data file? Is the limit of 20,000 still valid?¶
A UniPlot data file (NC2) can contain up to 20,000 channels (variables) and 20,000 attributes. This limit is still valid in current releases. Before UniPlot 5.15.1 the limit was 10,000. See UniPlot Data Files and netCDF Files for all limits of data files.
For files with more channels, split the file or reduce the number of channels before the import (see Why are channels missing after importing a large MF4/MDF file? Is there a channel limit?).
See also: Application Limits, Processing Large Data Files.
8.4.2. Why do some channels show the message “not loaded” in the Data Browser?¶
The message appears when the option Delayed Channel Import is active (MDF and TDM files). The data of a channel is then loaded only when it is needed. If the data is read from a slow drive, the loading can fail or take a long time. Options:
Disable Delayed Channel Import in Tools > More Options > Data Import and Data Browser (see Data Import and Data Browser) and import the file again.
To load the missing channel data of the open file, choose More Functions > Load delayed Channels in the shortcut menu of the Data Editor.
Copy the file to a local drive first.
See also: Data Import and Data Browser, Help=>Check Drive Speed.
8.4.3. Can I work with the document while the Data Browser edit window is open?¶
No. While the edit window of the Data Browser (Data Editor) is open, the document is blocked. After you create a formula channel, the diagram is partly accessible (for example you can set the cursor), but the cursor data table is not updated. Close the editor to work with the document normally.
See also: The Data Editor.