Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
AOjuva
Posted - 10/01/2021 : 06:32:46 AM Origin Ver. and Service Release (Select Help-->About Origin): Origin 2020 (64-bit) SR1 9.7.0.188
Operating System: Windows 10 pro
Has unstacking columns changed? I have a measurement file with a series of additions, each addition identified by a column called "annotations". The data file is largish, around 9k rows, and I have maybe seven additions (it takes time for the signal to stabilize after each addition). I have used the "Worksheet/Unstack columns" to group the data for each addition.
The problem is now that the grouped columns are not in order, which can be seen from the attached image where the row numbers series are from different parts of the main data. This is a bad problem that causes a lot of extra work. I don't remember seeing this earlier. Is there an easy fix?
2 L A T E S T R E P L I E S (Newest First)
AOjuva
Posted - 10/01/2021 : 09:20:22 AM That did the trick. Thank you! :)
YimingChen
Posted - 10/01/2021 : 08:56:37 AM The order of output columns depends on the order of the categorical variables in your "annotations" column. It looks like in your case +0.6290g is ahead of 0.0144 g NaAc in your main data. You can double click on the Categories column header of "annotations" column to adjust the ordering. https://www.originlab.com/doc/Origin-Help/ColProperties-Dialog-Categories-Tab