| Author |
 Topic  |
|
|
sam132
India
39 Posts |
 Posted - 09/14/2022 : 05:14:21 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):
OriginPro 2021 (64-bit)
9.8.0.200
Operating System: Win 11
My workbook has 5 columns where the first column (B) is the primary X axis and the next two columns (C, D) are the supposedly Y axis for one set of measurements,s and the remaining two (E, F) are the supposedly Y axis for the second set of measurement.
The data is stored in alternative rows for both sets of measurement. What I need to do is to segregate the workbook into two new workbooks where the first workbook contains the first set of measurements (column B, C, and D) with the empty row in 'C' and "D' deleted and the second workbook contains the second set of measurement (columns B, E, and F) with empty rows deleted.
(Please refer to the attached hyperlink for the image of the workbook)
https://drive.google.com/file/d/1elJiMy9N-kF1gNYVSHSdcXcEzjqVv20x/view?usp=sharing
How we can do that? Any help is appreciated.
Also, it would be good if this can be done in batches as I have hundreds of such workbooks.
|
|
|
snowli
USA
1432 Posts |
Posted - 09/14/2022 : 09:05:18 AM
|
You will need to use 2 tools in Origin for now. Also to be able to batch process other data, i would suggest output all results to same workbook.
Not sure your column starts with B.
1. Worksheet: Split Worksheet... and choose Split Mode as Number of columns. set the no. of columns to 2. Also Retain 1st 1 column. Set Output Worksheet to new sheet.
--> It will generate 2 sheets in same book. Each has one X and two Ys.
2. Then in each new sheet, choose Worksheet: Reduce Rows to remove missing values. U can set recalculation Mode to Auto and output to new sheet. Choose Reduce Mode as Delete rows with missing values.
-->After this, two more sheets are crerated with the results you want.
3. Choose File: Save Workbook as Analysis Template to save it as OGWU file.
4. Use File: Batch Processing tool.
Load this template and choose other files u want to process.
U can set Result Sheet to None.
Uncheck Delete Intermediate Workbook.
--> For each data, u will have a workbook with 5 sheets. The last 2 sheets are the result u want.
Thanks, Snow |
 |
|
|
snowli
USA
1432 Posts |
Posted - 09/14/2022 : 09:37:21 AM
|
BTW, i jiraed ORG-25734 to see if we can add option to remove rows with missing value in split worksheet tool.
Thanks, Snow |
|
|
| |
Topic |
|
|
|
Selecting certain rows in a workbook