Combining two CSV Files to a merged Product
Context
Procedure
- Open two or more CSV Files of interrest by double clicking them.
- Right mouse click on the header of a column in the table representation of the first CSV file. All other CSV files that are visible are listed as candidates to be combined with the actual CSV file.
- Choose a CSV file of interest via the context menu Merge with .... As a result the table is enlarged by the second CSV file and the legend on the right side as well. The column names in the table as well as in the legend now have a prefix. This prefix identifies to which of the CSV file they belong.
- Choose whether you want the graphs to be merged from another start point in time. You can also correct the title of the resulting table and chart.
- Choose the interesting columns to be displayed in the chart. Hint: It is easier to compare two graphs if you assign one graph to the left scale and the other to the right scale. This will keep the typical shape of the graphs recognizable. The result of a combination of CSV files can now be used as if it were a single CSV file. This means that you can
- Add virtual columns.
- Select a time interval for charting.
- Adjust the displayed columns to the left or right scale.