| T O P I C R E V I E W |
| elnino |
Posted - 10/14/2016 : 12:37:09 PM
Hi, now I have a script: int zeilenanzahl = 569596;
int indexC15=1;
wks.ncols = 3;
loop(jj,3,3)
{
for( ii = 1 ; ii <= zeilenanzahl ; ii++ )
{
if (wcol(jj-9)[ii]==12){
wcol(jj)[ii] = wcol(jj-1)[indexC15];
indexC15++;
}
}
}
It should work, but the calculation broke up and in the end I had only three columns, but my file has about 17!
My file has 569596 raws. Is it to much for Origin?
Does anybody has an idea? |
| 6 L A T E S T R E P L I E S (Newest First) |
| elnino |
Posted - 10/17/2016 : 10:10:44 AM
Hi Hideo Fujii,
thank you very much for These Information !!(= |
| Hideo Fujii |
Posted - 10/17/2016 : 09:35:50 AM
Hi elnino and other visitors to this thread,
> Could the Problem be that there are to many rows?
Just for your information, Origin (64-bit) worksheet can hold
90,000,000 rows (with <=5 columns).
So, 569,596 rows in your worksheet should be easily handled by Origin.
See more details at:
http://www.originlab.com/doc/Origin-Help/Origin-Limitation
Good luck,
--Hideo Fujii
OriginLab |
| elnino |
Posted - 10/14/2016 : 3:46:07 PM
I solved the Problem: for wks.ncols = I had to write 21 because I have 21 columns. Thank you for your help !! |
| elnino |
Posted - 10/14/2016 : 2:14:01 PM
Could the Problem be that there are to many rows? |
| elnino |
Posted - 10/14/2016 : 2:11:30 PM
Hi Hideo Fujii,
thank you for this advice!
int zeilenanzahl = 569596;
int indexC15=1;
wks.ncols = 3;
loop(jj,12,12)
{
for( ii = 1 ; ii <= zeilenanzahl ; ii++ )
{
if (wcol(jj-9)[ii]==12){
wcol(jj)[ii] = wcol(jj-1)[indexC15];
indexC15++;
}
}
}
Should it be now correct?
I tried it with this script but the same Problem occured. |
| Hideo Fujii |
Posted - 10/14/2016 : 1:42:19 PM
quote:
Originally posted by elnino
Hi, now I have a script: int zeilenanzahl = 569596;
int indexC15=1;
wks.ncols = 3;
loop(jj,3,3)
{
for( ii = 1 ; ii <= zeilenanzahl ; ii++ )
{
if (wcol(jj-9)[ii]==12){
wcol(jj)[ii] = wcol(jj-1)[indexC15];
indexC15++;
}
}
}
It should work, but the calculation broke up and in the end I had only three columns, but my file has about 17!
My file has 569596 raws. Is it to much for Origin?
Does anybody has an idea?
Hi elnino,
I don't understand your code exactly, but I see a few points at least:
1) The loop, "loop(jj,3,3) { ... }" doesn't make sense because it tells it 'loops' from 3 to 3 according to jj; that is it passes only once when jj=3.
2) Saying 1), as jj=3, the term "wcol(jj-9)[ii]" refers to the col(-6)!.
You can try to make a trace to check your code's behavior.
Hope this hints something.
--Hideo Fujii
OriginLab |
|
|
