Combining 2D Arrays that are FOR LOOP outputs into another 2D Array?

[murchak]

Each iteration from my for loop gererates a 2D array, with two columns, several rows, same headings

Iteration1          Interation2       Iteration3       etc.

A     B               A     B                A      B

1      2               3      4                5       6

7      8                                         9      10

Desired output:

A     B

1      2

7      8

3      4

5      6

9      10

I have tried putting build array inside the loop, outside the loop, played with cancatenate and append options, and tried to wire

the output of each iteration to the for loop's output tunnel with auto-index enabled (get 3D array 😞 ). Nothing seems to give me

what I want. I must be missing something simple. Can you please help? Note that the headings A, B appear once in the desired

output and the data are cancatenated.

Just a side: Each iteration is data read from an Excel sheet. I have many Excel sheets in a local drive, each containing data from a part tested.

My goal is to combine data from these Excel sheets and put them into one data file and upload them into an Oracle datadata base for data mining.

Am I going about this problem the right way? Should I combine all data first and then upload them into Oracle, or should I upload them one file at

a time? I do have Database Connectivity Toolkit. BTW, when you asnwer these questions, please don't forget to address my initial problem also 🙂

Thanks again!

[NitzZ]

Hi,

You an do it with a build array and shift registers. Check the attached VI. I used a read from spreadsheet instead of excel as i dont have excel toolkit. Hope you understand the logic.

Regards,

Nitzz

(Give Kudos to good Answers and Mark it as a Solution if your problem is Solved;))

[murchak · Accepted solution]

Thank you. I think this should solve my problem.