| Author |
 Topic  |
|
|
scalpa
France
Posts |
 Posted - 12/10/2020 : 10:39:40 AM
|
Origin 2021 and Service Release (Select Help-->About Origin):
Operating System:windows 10
Dear all,
Sorry for a probably very naive question: I'd like to develop a project in which I have one set of data (that I can amend over time) that undergoes different transformations and analyses, each of which being in a different folder. so all the analyses would operate on the same set of data (a "master" worksheet). If I correct this master worksheet, all the analyses would also immediatly be modified in their respective folders. "duplicate" doesn't work. How should I proceed ?
Thanks!
Scalpa |
|
|
YimingChen
1658 Posts |
Posted - 12/10/2020 : 10:51:38 AM
|
You can highlight the columns or entire worksheet to be duplicated, right click and select Copy Columns to..., this is an operation that can be part of your analysis template.
James |
 |
|
|
scalpa
France
Posts |
Posted - 12/10/2020 : 11:01:48 AM
|
Thanks a lot, it works very well ! Any chance I do the same with the entire workbook ?
Thanks again !
scalpa |
|
|
|
YimingChen
1658 Posts |
Posted - 12/10/2020 : 2:19:23 PM
|
Hi Scalpa,
You can use data connector to realize it. First prepare two project files, one just has the master workbook with the data (this project works as a data repository). In the second project, active a worksheet, select menu Data-> Connect to File-> Origin File, where you can choose the workbook to connect to.
This way, you can pulling data from project 1 and run analysis in project 2. Also analysis in project 2 will get updated upon any change of the data in project 1.
Please also check this blog:
http://blog.originlab.com/using-origin-project-as-data-repository-with-the-origin-connector
See if it works.
James |
Edited by - YimingChen on 12/10/2020 2:21:20 PM |
|
|
|
scalpa
France
Posts |
Posted - 12/11/2020 : 03:28:12 AM
|
I see.
It looks that it's exactly what I'm looking for!
thank you so much !
all best
Scalpa |
|
|
| |
Topic |
|
|
|
copy a worksheet