How to get value and calculate average of value in table

[Melanie23]

Hello dear all,
I am totally new on Labview, today I come to ask you two questions if you please.
In fact I'm retrieving measurement data from Labview and I have to:
firstly calculate the average of the values in table1
and secondly I have to do the sum of ( values index i of table1 multiply by values index i of table2).
Surely it is very simple but I do not know yet, thank you for your help

[GerdW]

Hi Melanie,

---

@Melanie23 wrote:

firstly calculate the average of the values in table1
and secondly I have to do the sum of ( values index i of table1 multiply by values index i of table2).

---

1. Use the Mean function…
2. Multiply both "tables" and use the ArraySum function…

(As I cannot open your LV2020 VI right now I guess when you write "table" you are using a numeric array instead.)

[crossrulz]

Could you supply more information on where this data is coming from?  It seems to me it would be a lot easier to do this process closer to the raw data instead of this formatted string.

[Melanie23]

Hi GerdW,

It's a 1D table with strings if it was only numeric in the table I could do the sum but with the strings in it I really don't know how to do it.
I've been looking for the function you're telling me about but I can't find it, can you show me when you're available please??
Best regards

[Melanie23]

Hi crossrulz,
Hi,
This data comes from another application on the bench, it would be very complicated to post it.
I'm in my first year BTS and it's my first day on LabVIEW and I just started, I'm asked to manipulate this data to calculate the average and do the multiplication in the meantime.
So if I can understand and manipulate these formatted data I could do the rest.
I am reading the LabVIEW course but I need some help 🙂

[GerdW · Accepted solution]

Hi Melanie,

---

@Melanie23 wrote:

It's a 1D table with strings if it was only numeric in the table I could do the sum but with the strings in it I really don't know how to do it.

---

So it is a 1D array of strings? ("Tables" are a 2D array of strings in LabVIEW!)

See this:

As you are new to LabVIEW I recommend to use QuickDrop:

When typing <Ctrl-space> a small dialog window opens and you can search for functions by typing just a part of their name.

By pressing <Enter> you can easily drop the selected function in your block diagram…

[Melanie23]

Hi GerdW,
Thank you for your answer I did not know about the table.
Please can you send me a snippet or the vi?
Thanks a lot.

[GerdW]

Hi Melanie,

---

@Melanie23 wrote:

Please can you send me a snippet or the vi?

---

Unfortunately I didn't save that tiny VI after creating the screenshot. But I show all the relevant function names so you can easily recreate it!

Why don't you talk with Steph? (S)he basically has the same issue, as he is using very similar string arrays with the same formatting of "key = value" for some unknown reason?

Are you students in the same class/group?