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
 Import Matlab files (Column / Row problem)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

FloTor

29 Posts

Posted - 05/22/2014 :  08:04:56 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 9.1
Operating System: win7 64 bit

Hi,

I want to import a .mat file from matlab. I used corresponding import function, however I do not manage, how I can transpose the data. The problem is, that the variables in matlab are saved as 1xn vectors. When I import this, Origin creates a column for each value instead of putting all values in one column as I want it to do. How can I achieve this? (Without transposing everything in Matlab).

lkb0221

China
497 Posts

Posted - 05/22/2014 :  10:32:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Can you try to transpose the worksheet after the importing? (Worksheet: Transpose)

Zheng
OriginLab
Go to Top of Page

snowli

USA
1386 Posts

Posted - 05/22/2014 :  10:36:00 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

I will check if we can improve this.

For now, in 9.1, during mat import, you can check "Import into Hierarchical Structure" checkbox under Import Options node?

Then all the variable structures will show in the workbook.
U can click the variable to put the data into new worksheet.
Choose Worksheet: Transpose menu to transpose the worksheet.

"Import into Hierarchical Structure" is a new feature added in 9.1. If you don't check it, then all variables will be put into the same worksheet and it's hard to transpose them together.


Thanks, Snow
Go to Top of Page

snowli

USA
1386 Posts

Posted - 05/28/2014 :  10:59:38 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi FloTor,

We are working on improving this so we would like to hear your feedback.

In post below, I mentioned you can check "Import into Hierarchical Structure" during import to import the structure first. But I am not sure if you used it before.

Do you need transpose to be supported for the flat import (all variable values imported in one sheet or do you want it to be supported if you check ""Import into Hierarchical Structure" as well?

BTW, you only want transpose for 1XN vectors right?

Thanks, Snow
Go to Top of Page

FloTor

29 Posts

Posted - 06/05/2014 :  09:14:43 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I only want to transpose 1xN vectors right now.
I think the transpose function would be particularly interesting for the flat import, but also for the hirarchical one.
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