Hello,
I am trying to plot a 3D diagram but unsuccessful. I have the data in Excel like this:
| Y | 4,15815757 | 10,5410784 | |
| X | Z1 | Z2 | |
| 0,00038225 | 0,04740562 | 0,09242527 | |
| 0,00032384 | 0,13448339 | 0,34250103 |
But I have a lot of rows and columns. This is just an example. I would appreciate any help.
Thanks.
The code works pretty good. I found out that I don't have enough memory available to run all the rows 104,284,944, that's why it didn't run.
I am using JMP 12.
Thank you very much.
'Daten.xlsx' has 23 Y values, 444 X values a Z value for each (10212 values in all). So shouldn't 'dtFinal' be:
dtFinal = New Table( "Converted", New Column( "X" ), New Column( "Y" ), New Column( "Z" ) );
dtFinal << add rows( N Rows( Xmat ) * N Rows( Ymat ) );
rowcnt = 0;
For( Xcnt = 1, Xcnt <= N Rows( Xmat ), Xcnt++,
For( Ycnt = 1, Ycnt <= N Rows( Ymat ), Ycnt++,
rowcnt++;
dtFinal:X[rowcnt] = Xmat[Xcnt];
dtFinal:Y[rowcnt] = Ymat[Ycnt];
dtFinal:Z[rowcnt] = Zmat[Xcnt, Ycnt];
)
);
givinhg somethkng like?
Without knowing anything about the data context and what you are attempting, I imagine that more informative visualisations are possible.