Array not pulling column headers from data source

[Ducky513]

Hi everyone, I am building my first vi in LabVIEW and can't seem to get my column headers to show up in my array. My assumption is that it has something to do with the string I'm bringing in containing letters and numbers but not 100% sure. 

You can see in my 1d array that I was able to get the column headers to come in but in my 2d version I can't seem to get it to come together. Thanks in advance for any help! 

[altenbach]

What is the value of the "format string" control? Have you tried %s?

[Ducky513]

Hi, it was blank at the time of the image but I did try %s and got the same result. 

[altenbach]

Your code makes absolutely no sense, but we cannot troubleshoot unless we know the value of the string.

Formatting a string into a string with a comma delimiter prepended makes no sense! delete that!

Maybe you want to define formats and delimiters for "spreadsheet string to array" instead.

Also wire maybe an empty 2D array of strings to the type input. (currently 1D).

It is difficult to debug pictures with wires flowing in all directions. Your DBL array is not even connected! Having two indicators with basically the same name is also confusing (Array vs array). Why not give reasonable labels?

See if this helps:

[Ducky513]

Thanks for that feedback. I had some things that I was trying as a solution hanging out on the diagram so I cleaned that up in the attached image. Hopefully that makes it more clear. 

In this new image, on the left side you can see in the array that all my data is showing up from my get request except my column headers and the value in the right most column. Where there should be text, there is just "0". 

Additionally, the put action is working correctly. After the concatenate strings block I send the data from the get request along with the appended value to my data source and that is working so the only thing I have to figure out here is the array part. 

[altenbach]

Look at my picture above. A text string cannot be translated into a number. 

Here are more details:

[Ducky513]

Could you help me to identify these five objects? I was unable to find them on the palette and have little experience as this is my first vi

[altenbach]

A: delete from array (inside array palette)

B: fract/exp string to number (inside string...number/string conversions palette)

C, D, E: just right-click the relevant output... create indicator. It will be of the correct type. resize on the front panel as needed.