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
 An easy way to set column types?

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
Flonares Posted - 12/13/2021 : 10:14:43 AM
Origin Ver. and Service Release (Select Help-->About Origin):9.7.0.188
Operating System: windows 10

Hello! I am currently importing several files into a single datasheet. These files consist of data in five columns (X, Y, XErr, YErr, Points). I wish to plot the Y, XErr, YErr data against a single X column. Unfortunately, when I import all files, all columns are labeled as Y, and it is quite tedious to go 1-by-1 to change them to the correct settings.

Is there a quick way to import all data in each file to the correct column type? I tried to look in the "multiple ASCII file import" but I failed to locate the correct settings.

Thanks for your help!

Best,

Al
3   L A T E S T    R E P L I E S    (Newest First)
snowli Posted - 12/13/2021 : 11:55:49 AM
The video shows how to set but didn't show what syntax to use.
U can go to
https://www.originlab.com/doc/Origin-Help/WksCol-SetDesignation

"Set Designation During Data Importing" part to see the letters for each designation.

Thanks, Snow
Flonares Posted - 12/13/2021 : 11:52:01 AM
Hello Snow,

That as a typo. I meant the first column is create as X but all others are create as Y.

Thanks for the video - I will try to see if I can adapt it to my problem.
snowli Posted - 12/13/2021 : 11:00:58 AM
Hello,

By default, the 1st column should be X so not sure why all your data are imported as Y.

Did you change the default workbook in Origin?

Also in ascii import dialog, expand the Column node, there is a Column Designation node to set what each columns are after import.
We just published a video including showing this column designation.
https://youtu.be/rD4-qHMOYyc

Thanks, Snow

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