The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Transpose results in columns during Batch Process?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
am17 Posted - 08/01/2017 : 07:39:18 AM
Hello,

I am following this batch processing tutorial from the OriginLab website. http://www.originlab.com/doc/Tutorials/Batch-Processing-Multiple-Datasets-using-Analysis-Template

However I would like to ask how I can output the dataset identifier in columns instead of rows like this picture attached here (basically I want to transpose the output results data during batch processing of multiple files):

Any ideas?

2   L A T E S T    R E P L I E S    (Newest First)
am17 Posted - 08/01/2017 : 1:23:24 PM
Thank you James for the prompt response. I had to update my Origin software to the latest 2017 version before I could finally get it to work.
YimingChen Posted - 08/01/2017 : 10:51:46 AM
Hi,

Basically you need to create a new Fit result sheet in your analysis template with the fitting result row transposed. Then during batch processing, you need to append the fitting results by columns. Here are the steps:
1. Open the analysis template in the tutorial, import data file "sensor1.dat" to generate result.
2. Add a worksheet "Fit Results2" at the end.
3. Go to Fit Resultssheet, copy the file name "Sensor01.dat", Go to the first column of "Fit Results2" sheet, and paste link to the column header long name.
4. Go to "Fit Results" sheet, copy first row except File name, and Paste Transpose to the first column of "Fit Results2".
5. Save analysis template.



6. In the Batch processing dialog, select the newly created template.
7. Set Result sheet to Fit Results2.
8. Set Append by to Columns.
Click OK to generate the result.



Hope this answers your question.

James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000