| T O P I C R E V I E W |
| dominik.mierzwa |
Posted - 02/18/2021 : 12:42:58 PM
Hi,
I have searched the forum but did not find any match. I often use "Append worksheets" with common columns. I would like to ask: is it possible to define the number of rows which should be appended? I think that Origin counts col(A) or first Xs and append this number of rows. The problem is that my dataset has a usually smaller number of rows than col(A) or first Xs. Thus, I need to remove empty rows from the result worksheet (I use the delete duplicates function).
Kind regards,
Dominik |
| 5 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 02/19/2021 : 09:24:41 AM
Sorry Dominik.
It looks this is a new feature in coming Origin 2021b (9.8.5) -- JIRA number: ORG-22912 so it's not in your version yet.
For now, you will have to remove the missing values after append.
Sorry for the confusing.
Thanks, Snow |
| dominik.mierzwa |
Posted - 02/19/2021 : 07:30:09 AM
If it were that simple, I wouldn't ask ;-)
Kind regards,
Dominik |
| snowli |
Posted - 02/18/2021 : 5:56:16 PM
I am not sure which version you are using.
Here it is.
Thanks, Snow |
| dominik.mierzwa |
Posted - 02/18/2021 : 3:33:49 PM
quote:
Originally posted by snowli
Hello,
Are you trying to append columns into a single column by setting Append by" as Row?
I tried that when you Append by rows and don't check "Append to the end of each column" checkbox, then those blank cells will be truncated.
Thanks, Snow
Yes, where this checkbox is? I did not notice it.
Kind regards,
Dominik |
| snowli |
Posted - 02/18/2021 : 3:07:12 PM
Hello,
Are you trying to append columns into a single column by setting Append by" as Row?
I tried that when you Append by rows and don't check "Append to the end of each column" checkbox, then those blank cells will be truncated.
Thanks, Snow |
