sum 2D array

[TomDooley]

Hello,

I'm working on a labView application and I want to sum the rows of a 2D array. The array gets the data form a INI file (see example)

[22022005]
Mea_0 = 1;2;5;9;12;47;2;25;86;56;89;45;23;12;12;10;9;6;5;3;1;1;2;0;0;0;0
Mea_1 = 2;3;6;10;13;48;3;26;87;57;90;46;24;13;13;11;10;7;6;4;2;2;3;1;1;1;1
Mea_2 = 5;7;6;10;13;48;3;26;77;77;90;46;24;13;13;11;29;7;6;4;2;2;3;1;3;1;1
Mea_3 = 8;12;6;10;13;48;3;26;87;97;113;76;64;33;53;41;36;7;6;4;2;2;3;4;1;1;1
Mea_n = .....
[Sum22022005]
Sum = 16;13;23;.......

The Mea's represents histogram data , I make a undefined quantity of measurements and save this to a file.
After 24h I build a array of all this measuremnt and I want to build the sum of the fields (for example)

Row1 field1 field2 ...
+Row2 field1 field2 ...
+Row3 field1 field2 ...
+Rown field1 field2 ...
------------------------
=sum fileds........

Can anybody help me

[GerdW]

Hello Tom,

there's a "Sum Array" at the math palette.
If you want to sum up the whole array just connect it.
If you want to sum only single rows/columns you have to use a for-loop to get one row after the other.#

Hope this helps,
GerdW

[NeilR]

Hi Tom

If I understand correctly you want to do something similar to that in attached vi.

Neil

[TomDooley]

Hello Neil,

almost yes. But I don't know how I can work it out, bcaus I read the spreadsheet string from the file and fill a arry inside a for loop. the result is a 3D array 😞 and here I stock.
Can you help me with the problem?

Thamks

Thomas

[TomDooley]

I did it. Thanks for your help. "You must speek about a problem" it's always the same 😉

Thomas

[Cyril]

Hi Tom

The problem lied in the fact that if you do not specify the type of array you want in the Spreadsheet string to array vi, it will convert it into a 2D array of Floats. The trick was to return a 1D array of Floats, so you have to wire a 1D array constant (see vi attached)

Also as you will see you can get rid of the parsing of the key name, since you already have an array of strings coming from the Get Key Names.vi. Just wire it to the border of the foor Loop with auto indexing (see vi attached)

regards,

[Cyril]

Oops forgot the attachment....sorry

[TomDooley]

Hi,

the attached vi is missing!

[TomDooley]

Thank you very much. It was a long way to go. But now I've understood.

Tom