Create a Graph from 2D Query Array

[Niccolo']

Hi everyone.

With the DB connection Toolkit i created a 2d array with 2 column:

-the first rapresenting different Temperatures

-the second with the related Date and Time

the current array is in String format because in DBL format i could not represent properly Date and Time

How can I can create a Chart where Temp=y and DateTime=x ??

I attached you the VI and a photo with the 2d array that comes from Running the query.

Thankyou for your help!!!

[Niccolo']

I use Transpose 2d Array to change column and field and then Index array to create two 1d array!

The nex step was to convert the two 1d array into numeric arrays! 

For the Temperature one is OK

But for the Date/Time array if i use the fract/exp string to number i get only the first number (for example 9/12/2010 ---> 9 )

How can i solve that?

Thanks!

[crossrulz]

So you want something like this?

[Gregory]

I wasn't familiar with Scan From String so I opened up a BD to wire it up. That VI should have a broken run arrow, right?

[crossrulz]

---

@Gregory wrote:

I wasn't familiar with Scan From String so I opened up a BD to wire it up. That VI should have a broken run arrow, right?

---

Weird. The wire dissappeared when creating the snippet.  But dropping the snippet onto my block diagram and everything is there.  There should be a wire going from the autoindexing tunnel to the Input String on the Scan From String.

[Gregory]

I figured, the reason I wanted to "investigate" was because I couldn't think of a good reason to leave that auto-index tunnel disconnected

[crossrulz]

Here is another snippet that appears to have worked properly.

[Niccolo']

Croosrulz thanks so much.

Just 2 thinks:

1)the Vis gives me Error in the Scan from String

I atteched you the photos.

2)Is it possible to have a Bar graph instead of the normal one?

[crossrulz]

You indexed the Row.  You should index the Colum (which is the second index input on the Index Array)

[Niccolo']

ok, last thing:

How can i change the scale of X and Y in the Graph in the front panel? cause now it's hardly impossible to see the Temp values