| T O P I C R E V I E W |
| AKazak |
Posted - 04/29/2020 : 1:20:00 PM
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. |
| 4 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 05/05/2020 : 4:26:24 PM
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. |
| aplotnikov |
Posted - 04/29/2020 : 6:31:15 PM
1.Import CSV "as is" (Import Mode: "Start New Columns").
2.Use Labtalk to delete redundant X-columns in a loop. |
| AKazak |
Posted - 04/29/2020 : 5:46:54 PM
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 |
| aplotnikov |
Posted - 04/29/2020 : 4:57:36 PM
1. Start Import Wizard and select files.
2. Set Import Mode: Start New Columns
3. Partial Import settings as follows:
 |
