| T O P I C R E V I E W |
| JimThieser |
Posted - 04/09/2022 : 2:23:31 PM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
Hi,
i would like to extract several data in a new datasheet.
We are for example a colum with the number of measurement..
And for each measurement we have several measurement points...
So it looks like
measurement Operatrionpoint
1 1
1 2
1 3
2 1
2 2
2 3
3 1
.
.
.
And now I would like to extract each Measurement in a new datasheet.
but I don't know how to get the right column indexs because the numer of operations point varies so i have no aquidistant difference between the measurements...
Any ideas???
Thanks
|
| 1 L A T E S T R E P L I E S (Newest First) |
| aplotnikov |
Posted - 04/09/2022 : 4:43:00 PM
Hi JimThieser,
there are at least two possibilities - you can use either the wxt-X-function or the worksheet filtering.
In the first case you will get the list of indexes, in the second case you can simply read the filtered data to a string array and then assign the values (after conversion to numeric format) to a dataset. If you try to assign the filtered data directly to a (numeric) dataset you will get an array of the filtered numeric values but with empty entries for hidden rows, that is very inconvenient. If you use string array, you do not need to know indexes at all. And it works relatively fast.
This difference in assignment of filtered values exists in the most recent version, I have not checked previous ones.
Alexei |
|
|
