Skip to main content
R
Raiko17-Peridot
17-Peridot
September 1, 2010
Solved

Unnesting arrays automatically

  • September 1, 2010
  • 4 replies
  • 7210 views

Hi fellow MCers,

is there an automated way to "unnest" an array?

I have a huge amount of excel files from which I read in some data. These are all displayed in a nested array (see attached image). As I have really many files I don't wish to call up every single array element manually.

Thanks

Raiko

P.S.

I have made a search for this topic beforehand, but the attachements are missing in the relevant posts 😞

FURTHERMORE

Why is it that the time stamps are put into a nested array instead of a "simple" array?

I'm reading in the time line information from Excel files and had hoped to arrange them according to the time differences. However, in order to compute them I need to access the cells of a nested array. Displaying a nested array is fine but doesn't exactly solove my problem.

Any ideas?


Raiko

Best answer by FDS

Maybe you could try format -> results -> Display Options -> check Expand nested arrays

4 replies

F
FDS13-AquamarineAnswer
13-Aquamarine
September 1, 2010

Maybe you could try format -> results -> Display Options -> check Expand nested arrays

R
Raiko17-PeridotAuthor
17-Peridot
September 1, 2010

Hi desomer,

thank you very much - that did the trick. Checking unnest array and displaying said array as a matrix worked fine.

Cheers

Raiko

R
RichardJ19-Tanzanite
19-Tanzanite
September 1, 2010

Your "i" should run from 0 to 16, not 1 to 17 (the origin for al arrays is 0). That's why the first element of your array is a zero.

Change XY[i to XY Ctrl 6 i (column operator). The return the transpose of XY. Your array should then be a vector (I think - I haven't tried it to be certain)

M
MikeArmstrong1-Visitor
1-Visitor
September 1, 2010

Please post a worksheet if possible.

Mike

R
Raiko17-PeridotAuthor
17-Peridot
September 2, 2010

Here we go

Raiko

J
jeanGiraud1-Visitor
1-Visitor
September 2, 2010

Raiko Milanovic wrote:

Here we go

Raiko

Here, it goes nowhere !

Post a work sheet wherein the results are nested, and don't zip !

You have a folder, what's a folder ? an empty folder,

a folder of what ? If you have data in that folder, put them in a

Mathcad data table. How can we know what has to be unested ?

Vertical nest ? horizontal nest ?

J
jeanGiraud1-Visitor
1-Visitor
September 1, 2010

You seem to have a simple extract, maybe not done correctly. Lot of Mathcad results come out nested. Sometimes it's possible to unest from the costruct, sometimes it is not or messy.

R
Raiko17-PeridotAuthor
17-Peridot
September 2, 2010

Cher Jean

merci beaucoup pour votre aide

Raiko

Terms & ConditionsAccessibility statement