| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 Posted - 07/05/2022 : 02:24:39 AM
|
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
I need to select multiple columns based on a condition.
Can Worksheet Query help me doing this?
If negative, then what Origin tool can I use?
Thank you.
---
Andrey |
|
|
Cecilia_syy
65 Posts |
Posted - 07/05/2022 : 02:35:20 AM
|
Hi Andrey,
Could you try Select... under Edit menu?
Thanks
Cecilia |
 |
|
|
AKazak
Russia
1205 Posts |
Posted - 07/05/2022 : 04:06:20 AM
|
quote:
Originally posted by Cecilia_syy
Hi Andrey,
Could you try Select... under Edit menu?
Thanks
Cecilia
Dear Cecilia,
It works, but how can I set more sophisticated conditions similar to Worksheet Query?
---
Andrey |
|
|
|
Cecilia_syy
65 Posts |
Posted - 07/05/2022 : 05:09:18 AM
|
Hi Andrey,
Could you provide your user story about "more sophisticated conditions" to select columns? Then we can check how to improve Select dialog.
Thanks
Cecilia |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 07/05/2022 : 05:32:55 AM
|
quote:
Originally posted by Cecilia_syy
Hi Andrey,
Could you provide your user story about "more sophisticated conditions" to select columns? Then we can check how to improve Select dialog.
Thanks
Cecilia
Dear Cecilia,
Example 1: I need to remove columns with a condition on a value in 10-th row.
Example 2: I need to remove columns with a condition on an integral value (sum, mean, etc.) of the column.
Example 3: I need to remove columns with a condition on presence of masked cells.
Example 4: I need to remove columns with a condition on number of masked cells.
---
Andrey |
|
|
|
Cecilia_syy
65 Posts |
Posted - 07/06/2022 : 01:42:15 AM
|
Hi Andrey,
We have a similar requirement to hide columns base on a value in N-th row, so I update your case in that jira(ORG-20565) too.
Currently this Select dialog is quite simple, we may not want to complicate it with condition like worksheet query. For your example 2~4, I think you can add user parameter with formula first.
1. remove columns with a condition on an integral value (sum, mean, etc.) of the column. -- You can add Sum Mean label row with user parameter dialog. Then select dialog could select column base on sum or mean of column and delete.
2. remove columns with a condition on presence of masked cells or number of masked cells. -- You can add user parameter with formula =ismasked(0,This). Then this label row will show number of masked cell in each column. Then select dialog could select column base on this label row and delete.
Thanks
Cecilia |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 07/06/2022 : 01:46:00 AM
|
quote:
Originally posted by Cecilia_syy
Hi Andrey,
We have a similar requirement to hide columns base on a value in N-th row, so I update your case in that jira(ORG-20565) too.
Currently this Select dialog is quite simple, we may not want to complicate it with condition like worksheet query. For your example 2~4, I think you can add user parameter with formula first.
1. remove columns with a condition on an integral value (sum, mean, etc.) of the column. -- You can add Sum Mean label row with user parameter dialog. Then select dialog could select column base on sum or mean of column and delete.
2. remove columns with a condition on presence of masked cells or number of masked cells. -- You can add user parameter with formula =ismasked(0,This). Then this label row will show number of masked cell in each column. Then select dialog could select column base on this label row and delete.
Thanks
Cecilia
Dear Cecilia,
Got it.
Hope to test the improved version of the Select dialog.
---
Andrey |
|
|
|
JacquelineHe
287 Posts |
Posted - 05/06/2023 : 02:05:28 AM
|
Hi,
Origin 2023b is available!
Some new features are supported, or issues are fixed.
The issue "Improvement on Worksheet Select Columns" (ORG-20565) has been fixed in this version.
Please download Origin 2023b from the link below, install and try it.
http://www.originlab.com/demodownload.aspx
We are looking for your feedback! Any suggestion will be appreciated!
Best regards,
Jacqueline He
OriginLab
|
|
|
| |
Topic |
|
|
|
Worksheet Query: column-wise mode