Build an array from multiple arrays

[Radioman00]

Hi,

i am currently trying to build a program which builds and displays one gaussian (graph) from multiple optical spectral results (aquired and each saved on a different spreadsheet file). The results will all me saved with the wavelength and the file name will each have appended a number: 

so  i will have multiple spreasheet files...   1.txt : 1550 , -90          2.txt: 1550, -85    etc...

i want to put these all into a single array, or spread sheet so that i can display it all as 1 gaussian curve:  1, -90    2, -85   etc..

can anyone help? i was thinking a while look to append the spreadsheet files i recal within the loop, but this does not seem to be workin

thanks a lot,

Asiri  

[Harold_Timmis]

use the build array function

[Radioman00]

the spreadsheets are only coming from 1 source. .. the 'read from spread sheets' VI, (so to clarify, i have multiple spreadsheets with a wavelnth, x-value, and its corresponding power value) i want to put them all into 1 file so i can display it as 1 curve, with build array i need multiple inputs, which i do not have 😞 

any solution to this?

thanks a lot!  

[jack47 · Accepted solution]

 Something like this?  Load the file take the first column and build a 2-d array for the columns?  It may need to be transposed, I'm not sure.

[Radioman00]

Thanks a lot, i think thats exactly what i am looking for! 😄 

[Radioman00]

sorry, but which VI is that? the file path one used right in the beginning? i am fairly new to labview and not familiar with all the components yet 🙂

asiri  

[elset191]

It's an array of filepaths.  Drop an array constant, then drop file path constant into it.  Of course this can be a control too.