Ignition 8.1.23
I have a table with a series of measurements at different dates. This is in wide format with a "row" for each date and "columns" for each measurement. This data is inserted into SQL by parsing a text file created by a CNC machine. It is not tag historian data.
I have written a simple script that queries the SQL table and returns a dataset. The dataset is set up as a parameter in the report and I can plot it on a time series chart. However, to do so, I have to manually type in the range key names. This will not work as a solution because the name of each measurement is dynamic as is the number of measurements.
Essentially, I have a dataset input with variable number of keys and variable key names.
Please can someone suggest a better way to achieve my desired result?
Cheers