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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Join Worksheets by Column with Categorical ref
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1205 Posts

Posted - 05/19/2022 :  05:40:01 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

snowli

USA
1411 Posts

Posted - 05/19/2022 :  09:13:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

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

Best, Snow
Go to Top of Page

AKazak

Russia
1205 Posts

Posted - 05/19/2022 :  09:23:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1411 Posts

Posted - 05/19/2022 :  11:59:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
1205 Posts

Posted - 05/19/2022 :  12:58:30 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1411 Posts

Posted - 11/10/2022 :  5:41:17 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

This fix is also in official Origin 2023.

Thanks, Snow
Go to Top of Page

AKazak

Russia
1205 Posts

Posted - 11/12/2022 :  03:32:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000