| Author |
 Topic  |
|
|
hesaboogie
12 Posts |
 Posted - 02/24/2012 : 06:00:46 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System: Windows XP
hi,
i have a sheet with a column in which only a view values are possible (mainly 0.1 and 0.2). Now i want to extract the data in new sheets, which differentiate the rows by the value in the specified column, so i get one sheet with only the data belonging to the 0.1 value and another sheet with only the data belonging to the 0.2 value. All other data can be neglected.
I know how i can get data from another sheet with
range rXY = Sheet1!col(1);,
but i don't know how i can specify only certain values. Is it possible to do that?
Thanks in advance,
theresa.
|
|
|
Drbobshepherd
USA
Posts |
Posted - 02/24/2012 : 10:21:23 AM
|
Try the X-function wextract. With it, you can pass an input range, an output range, and a settings tree-variable in which you have defined the conditions for your extraction(e.g. "col(A)<0.2").
DrBobShepherd |
 |
|
|
hesaboogie
12 Posts |
Posted - 02/27/2012 : 05:01:20 AM
|
Thank you for your answer.
I searched the originhelp for "wextract" to see the exact syntax (i'm new to origin) but it failed ("No results"), so i tried "extract" and found the topic "Worksheet Query". I think in my case it does the same than "wextract" but in a "assisted" way?
Or are there any advantages i didn't see?
theresa. |
|
|
|
Drbobshepherd
USA
Posts |
Posted - 02/27/2012 : 10:02:07 AM
|
| I had no problem finding "wextract" the help files. Try searching with the Help/Programming/Main pulldown menu, or Help/Programming/X-functions. |
|
|
|
hesaboogie
12 Posts |
Posted - 02/27/2012 : 10:08:11 AM
|
| ah, i looked in the Help->Origin files, thanks! |
|
|
|
hesaboogie
12 Posts |
Posted - 03/12/2012 : 07:21:39 AM
|
Hi,
i will add this to this topic because it's related.
I made the extraction with the worksheet query and it had worked fine. Now i want to do it again (with other parameters) and extract data to another sheet, also with recalculate "Auto". But if i now choose this, the apply button is greyed out and i cannot extract the data. With the auto-recalculation i can only
- add a true/false column
- fill with specified color or
- select
the data and the apply button is clickable.
I cannot explain this behaviour, because i didn't change anything in the meantime (i think so, the sheets that i previously extracted are still on auto recalculation). |
|
|
|
easwar
USA
1964 Posts |
Posted - 03/12/2012 : 8:27:54 PM
|
Hi,
When setting recalculate mode to Auto, the Apply button is not available for some options such as the ones that create an output sheet/book. But the OK button should be available? You can click OK to create the output. Then in the output you will see locks, and you can click on the lock and select "Change parameters..." to re-open the dialog if you want to make any changes to your conditions etc.
Easwar
OriginLab |
|
|
|
hesaboogie
12 Posts |
Posted - 03/13/2012 : 11:50:22 AM
|
That's it, thanks a lot!  |
|
|
| |
Topic |
|
Extract only certain values of a different sheet