The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Join Worksheets by Column with Categorical ref

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
AKazak Posted - 05/19/2022 : 05:40:01 AM
OriginPro 2022b (64-bit) SR1 9.9.5.167
Windows 7 Pro SP1 x64

Greetings!

I noticed that Join Worksheets by Column command called from GUI does not match actual column values if one or both reference columns are set as Categorical.

It would be nice it the command had an option what values to match: actual or category index.

Does it make sense?

---
Andrey
6   L A T E S T    R E P L I E S    (Newest First)
AKazak Posted - 11/12/2022 : 03:32:13 AM
quote:
Originally posted by snowli

Hi Andrey,

This fix is also in official Origin 2023.

Thanks, Snow



Dear Snow,

Great news!
I will report here if find issues with this.

---
Andrey
snowli Posted - 11/10/2022 : 5:41:17 PM
Hi Andrey,

This fix is also in official Origin 2023.

Thanks, Snow
AKazak Posted - 05/19/2022 : 12:58:30 PM
quote:
Originally posted by snowli

Hi Andrey,

Thanks. I created ORG-25262 for this.

Actually i am not sure in what case user wants to match categorical index. I suppose it should always follow actual text.

Thanks, Snow




Dear Snow,

I agree with you.
I use Categorical for plotting and current I create a dummy not-categorical reference column to use Join Worksheets by Column.

---
Andrey
snowli Posted - 05/19/2022 : 11:59:23 AM
Hi Andrey,

Thanks. I created ORG-25262 for this.

Actually i am not sure in what case user wants to match categorical index. I suppose it should always follow actual text.

Thanks, Snow
AKazak Posted - 05/19/2022 : 09:23:44 AM
quote:
Originally posted by snowli

Hi Andrey,

Could you share an opju so we can better understand the issue?

Best, Snow



Dear Snow,

Here you are:
https://my.originlab.com/ftp/forum_and_kbase/Images/Join%20Worksheets%20by%20Column.opju

---
Andrey
snowli Posted - 05/19/2022 : 09:13:41 AM
Hi Andrey,

Could you share an opju so we can better understand the issue?

Best, Snow

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000