09-09-2013 10:23 AM
Ok, now that I know what is happening, this is an easy fix. Two things:
Array: Take the reading of your Array file out of the FOR loop. It only needs read once. The autoindexing of the output on the FOR loop is just making it a 3D array.
Array 2: Change the data type for the Spreadsheet String to Array to a 1D array of string.
For the combining, I think you will need to use Transpose 2D Array on the main array, then use Build Array to append Array 2 to Array. Then transpose again to put it all the way you want.
09-09-2013 10:43 AM - edited 09-09-2013 10:44 AM
Ok, I have a small correction where I told you to use Build Array. You will need to transpose Array 2 as well. Here I gave you 2 options of appending columns to a 2D array.