| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 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 |
|
|
Shirley_GZ
China
Posts |
Posted - 06/10/2022 : 03:50:57 AM
|
Hi AKazak,
Yes, wdeldup can do this:
Thanks,
Shirley
Originlab Technical Service Team |
 |
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
ChaoC
USA
185 Posts |
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
Russia
1205 Posts |
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 |
|
|
|
AKazak
Russia
1205 Posts |
Posted - 07/09/2022 : 04:14:07 AM
|
OriginPro 2023 (64-bit) Beta 1 10.0.0.47 doesn't feature the improvement.
---
Andrey |
|
|
|
ChaoC
USA
185 Posts |
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
Russia
1205 Posts |
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
USA
185 Posts |
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
Russia
1205 Posts |
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
USA
185 Posts |
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
Russia
1205 Posts |
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
USA
185 Posts |
Posted - 11/09/2022 : 12:36:58 PM
|
Hello Andrey,
ORG-25369 improvements to wdeldup is included in Origin 2023.
Best,
Chao |
|
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
| |
Topic |
|
wdeldup with separate reference and merge columns