| T O P I C R E V I E W |
| AKazak |
Posted - 04/17/2020 : 11:07:22 AM
Origin Ver. and Service Release (Select Help-->About Origin):
OriginPro 2019b (64-bit)
9.6.5.169
Operating System: W7 Pro x64 SP1
Greetings!
How do I remove duplicated rows based on multiple columns?
Origin provides at least three methods to remove the duplicated data, which are:
1) "Worksheet> Remove/Combine Duplicated Rows" menu (wdeldup), and
2) "Analysis> Data Manipulation> Reduce Duplicated X Data" menu (reducedup)
3) "Unique(<column>)" command.
However, all listed above scan through or search for duplicates in one single column.
How do I stack multiple columns to feed to one of the listed commands?
Thank you. |
| 8 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 04/22/2020 : 2:42:25 PM
quote:
Originally posted by nick_n
$ is identifier of string variable. Thus, look: "LabTalk, Data Types and Variables, String":
https://www.originlab.com/doc/LabTalk/guide/Data-Types-and-vars#String
Udachi,
Nikolay
Thanks a lot!
The original questions seems to be answered. |
| nick_n |
Posted - 04/22/2020 : 12:36:53 PM
$ is identifier of string variable. Thus, look: "LabTalk, Data Types and Variables, String":
https://www.originlab.com/doc/LabTalk/guide/Data-Types-and-vars#String
Udachi,
Nikolay |
| AKazak |
Posted - 04/22/2020 : 12:15:01 PM
quote:
Originally posted by nick_n
Privet,
The same way but with SPACE:
A$+" "+B$.
Regards,
Nikolay
Nikolay, spasibo very much!
Where can I read more about $-string modifiers?
I skimmed over the help, but could not find a comprehensive explanation of $'s role. |
| nick_n |
Posted - 04/21/2020 : 04:33:38 AM
Privet,
The same way but with SPACE:
A$+" "+B$.
Regards,
Nikolay |
| AKazak |
Posted - 04/21/2020 : 04:19:51 AM
That seems to be a promising workaround!
My columns contain real numbers, rather than text.
How do I combine two numeric values similar to the text?
Thank you. |
| YimingChen |
Posted - 04/20/2020 : 10:44:33 AM
Hi,
One workaround would be to create a new column, fill with the combined text from all reference columns (see below as an example), then run the tool referencing on that column.
James |
| AKazak |
Posted - 04/18/2020 : 05:50:23 AM
quote:
Originally posted by YimingChen
Hi,
This is a known issue. We improved Remove/Combine Duplicated Rows tool in Origin 2020b to support multiple columns as reference. Just let you know the new version will release shortly. Thank you.
James
Dear James,
Great news!
What is a viable workaround for the 2019b?
Thank you. |
| YimingChen |
Posted - 04/17/2020 : 5:14:37 PM
Hi,
This is a known issue. We improved Remove/Combine Duplicated Rows tool in Origin 2020b to support multiple columns as reference. Just let you know the new version will release shortly. Thank you.
James |
