The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

wsplit/wAppend 1000 sheet limit

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by zknauss[/i]
[br]good morning,

I have a set of data where each subject has multiple peaks in its wave form and when processed through the peak analyzer come out looking like (image A). From this output I reorganize the data so that each measure (ex. peak amplitude) gets its own sheet with each column representing a single subject and each row the data from the corresponding peak (image B). The analysis code I have has been working well, however, I run into an issue when my subject count gets around 1000 as the number of sheets needing to be made exceeds the maximum sheet allowance of 1000. What I need is a viable work around that will allow the analysis to move forward in the case of a subject count over 1000. Critically, this needs to be done with minimal changes to how the data is structured in the final output, as the rest of my analysis script rely on this format. Below is the current script I'm utilizing to reorganize the data. Thanks in advance -ZTK

[code]wsplit mode:=ref ref:=[NCONT1ROI]1!A"Dataset ID" keepref:=0 missing:=0 keep:=0 sparkline:=0 owp:=<input> name:=<[<%V>]>; 
wAppend irng:=[NCONT1ROI]  ow:=[NCONT1ROI]<new name:=Sorted>;
wsplit iw:=[NCONT1ROI]Sorted! owp:=[NCONT1Peak] mode:=label label:=L copyform:=copyexc;[/code]

[img]https://my.originlab.com/ftp/forum_and_kbase/Images/Image%20A.PNG[/img]
[img]https://my.originlab.com/ftp/forum_and_kbase/Images/Image%20B.PNG[/img]

ZTK
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
zknauss	Posted - 09/30/2022 : 09:00:09 AM good morning, I have a set of data where each subject has multiple peaks in its wave form and when processed through the peak analyzer come out looking like (image A). From this output I reorganize the data so that each measure (ex. peak amplitude) gets its own sheet with each column representing a single subject and each row the data from the corresponding peak (image B). The analysis code I have has been working well, however, I run into an issue when my subject count gets around 1000 as the number of sheets needing to be made exceeds the maximum sheet allowance of 1000. What I need is a viable work around that will allow the analysis to move forward in the case of a subject count over 1000. Critically, this needs to be done with minimal changes to how the data is structured in the final output, as the rest of my analysis script rely on this format. Below is the current script I'm utilizing to reorganize the data. Thanks in advance -ZTK wsplit mode:=ref ref:=[NCONT1ROI]1!A"Dataset ID" keepref:=0 missing:=0 keep:=0 sparkline:=0 owp:=<input> name:=<[<%V>]>; wAppend irng:=[NCONT1ROI] ow:=[NCONT1ROI]<new name:=Sorted>; wsplit iw:=[NCONT1ROI]Sorted! owp:=[NCONT1Peak] mode:=label label:=L copyform:=copyexc; ZTK
2 L A T E S T R E P L I E S (Newest First)
zknauss	Posted - 09/30/2022 : 10:16:12 AM I think that could work I'll play around with it and update if sucsessful ZTK
YimingChen	Posted - 09/30/2022 : 09:40:07 AM You can use Unstack Columns tool repeatedly on each column of the Batch PA result sheet. Try the script below: int nn = wks.ncols; for (int i = 2; i <= nn; i++) { wunstackcol -r 2 irng1:=[NCONT1ROI]1!$(i) irng2:=[NCONT1ROI]1!A ow:=[<new>]<new>; } James

The Origin Forum

Snitz Forums 2000