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
 Merging text data files to single worksheet		  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 - 04/29/2020 :  1:20:00 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2019b (64-bit) 9.6.5.169
Windows 7 Pro x64 SP1

Greetings!

I have a set of two-column CSV files:
1.CSV with columns X Y1
2.CSV with columns X Y2
3.CSV with columns X Y3
...
nn.CSV with columns X Ynn

where X column is exactly the same for all the files.


What is an elegant way to import this set of files to a single multi-column worksheet?
X Y1 Y2 ... Ynn

Thank you.
Edited by - AKazak on 04/29/2020 1:20:28 PM

aplotnikov

Germany
160 Posts
Posted - 04/29/2020 :  4:57:36 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
1. Start Import Wizard and select files.
2. Set Import Mode: Start New Columns
3. Partial Import settings as follows:
Go to Top of Page

AKazak

Russia
1205 Posts
Posted - 04/29/2020 :  5:46:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by aplotnikov

1. Start Import Wizard and select files.
2. Set Import Mode: Start New Columns
3. Partial Import settings as follows:


Great idea!

How do I extend this workflow to a case of mm samples, where each sample has nn data files?

01 01.CSV
...
01 nn.CSV
...
mm 01.CSV
mm nn.CSV

In the result I want to get sample sheets "01" ... "mm", where each sample sheet has:
X Y1 Y2 ... Ynn
Go to Top of Page

aplotnikov

Germany
160 Posts
Posted - 04/29/2020 :  6:31:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
1.Import CSV "as is" (Import Mode: "Start New Columns").
2.Use Labtalk to delete redundant X-columns in a loop.
Go to Top of Page

AKazak

Russia
1205 Posts
Posted - 05/05/2020 :  4:26:24 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by aplotnikov

1.Import CSV "as is" (Import Mode: "Start New Columns").
2.Use Labtalk to delete redundant X-columns in a loop.


Thank you.
I followed your suggestion.
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