| T O P I C R E V I E W |
| AKazak |
Posted - 06/10/2022 : 03:22:40 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64
Greetings!
Does wdeldup allow achieving the following result?
If negative, then what function(s) may help?
Thank you.
---
Andrey |
| 13 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 11/09/2022 : 1:43:15 PM
quote:
Originally posted by ChaoC
Hello Andrey,
ORG-25369 improvements to wdeldup is included in Origin 2023.
Best,
Chao
Dear Chao,
Got it!
Thank you for notifying.
---
Andrey |
| ChaoC |
Posted - 11/09/2022 : 12:36:58 PM
Hello Andrey,
ORG-25369 improvements to wdeldup is included in Origin 2023.
Best,
Chao |
| AKazak |
Posted - 07/12/2022 : 09:36:13 AM
quote:
Originally posted by ChaoC
Hi Andrey,
wdeldup is under the Worksheet tab as it is used to reduce the rows of the entire worksheet, not just a single column.
Reference columns are the criteria used to determine how to reduce these rows.
If you reduce the rows in one column and not the other, you would end up with mismatched data.
Chao
Dear Chao,
Got it.
Thanks.
---
Andrey |
| ChaoC |
Posted - 07/11/2022 : 2:09:51 PM
Hi Andrey,
wdeldup is under the Worksheet tab as it is used to reduce the rows of the entire worksheet, not just a single column.
Reference columns are the criteria used to determine how to reduce these rows.
If you reduce the rows in one column and not the other, you would end up with mismatched data.
Chao |
| AKazak |
Posted - 07/11/2022 : 11:21:14 AM
quote:
Originally posted by ChaoC
Hi Andrey,
It will sum all the columns that are numeric and not a reference column.
Chao
Hm...
This is not obvious at all.
Does it make sense to add a column(s) selector to do mathematical manipulations listed in Merge Duplications by drop-down menu?
---
Andrey |
| ChaoC |
Posted - 07/11/2022 : 11:16:29 AM
Hi Andrey,
It will sum all the columns that are numeric and not a reference column.
Chao |
| AKazak |
Posted - 07/11/2022 : 10:53:40 AM
quote:
Originally posted by ChaoC
Hi Andrey,
This improvement is in the 2023 Beta1.
Using the example in your first post:
Did you mean something else?
Chao
Dear Chao,
You are right, it works!
However I still don't get the point: how do you select a data column to Sum?
---
Andrey |
| ChaoC |
Posted - 07/11/2022 : 10:46:49 AM
Hi Andrey,
This improvement is in the 2023 Beta1.
Using the example in your first post:
Did you mean something else?
Chao |
| AKazak |
Posted - 07/09/2022 : 04:14:07 AM
OriginPro 2023 (64-bit) Beta 1 10.0.0.47 doesn't feature the improvement.
---
Andrey |
| AKazak |
Posted - 06/10/2022 : 11:21:08 AM
quote:
Originally posted by ChaoC
Hi Andrey,
In your attached project, if you set column B as Text, the results should be as you expect. This may not be desirable in every case so I have created ORG-25369 for improvement.
Thanks,
Chao
Dear Chao,
This was not obvious at all.
I hope to get it fixed or have an additional option in the next beta version.
---
Andrey |
| ChaoC |
Posted - 06/10/2022 : 10:43:56 AM
Hi Andrey,
In your attached project, if you set column B as Text, the results should be as you expect. This may not be desirable in every case so I have created ORG-25369 for improvement.
Thanks,
Chao |
| AKazak |
Posted - 06/10/2022 : 05:21:27 AM
quote:
Originally posted by Shirley_GZ
Hi AKazak,
Yes, wdeldup can do this:
Thanks,
Shirley
Originlab Technical Service Team
Dear Shirley,
I also thought that this is the case.
Please see the attached project:
https://my.originlab.com/ftp/forum_and_kbase/Images/wdeldup2022-06-10.opju
I want to identify Duplicates by columns A and B, but Sum column C.
However, I observe that wdeldup sums column B and C.
How do I specify where to search for duplicates and what to sum?
---
Andrey |
| Shirley_GZ |
Posted - 06/10/2022 : 03:50:57 AM
Hi AKazak,
Yes, wdeldup can do this:
Thanks,
Shirley
Originlab Technical Service Team |
