search for a special date

[ditsch]

Hello,

I would like to know how it is possible to access from the Citadel Database(ODBC) to show this in Diadem (automatically) ?

when I put a single chart I see 

the values but some values have NoN(Not a Number) and some of them are nothing.(an empty field) . It is possible the empty field automatically fill it with for instance with zeros?

and the second question: how it is possible in the chart automatically or manual to search a special date?

 for instance (I want to show the 10,15...20,28. of the same month in the diagram)

best regards

ditsch 

[Brad_Turpin]

Hi ditsch,

You mentiond the ODBC connection to Citadel, but there is a nicer, more native option built into DIAdem-- you can create a Data Store configuration to your Citadel data base.  When you select this configured Data Store in DIAdem, you will see the entire Citadel data base structure as a tree view in the DIAdem NAVIGATOR, and you can directly drag&drop desired Citadel traces from the NAVIGATOR into the DIAdem Data Portal at the right of your DIAdem window.  Built into the Data Store configuration for a Citadel data base is the ability to set a desired time window.  This will not pull out only certain days of each month, but it will eable you to limit the data retrieving to only the months/years that you care about.

Have you succeeded in loading your Citadel data into DIAdem yet?  If not, have you succeeded in querying your Citadel data through the ODBC connection-- and if you have, what program were you using to run the SQL query to return this data?

Regardless of whether you load the data into DIAdem from a Data Store or an SQL query using the ODBC connection, once the data is in the DIAdem Data Portal, we will be able to remove the unwanted days either manually like in Excel or programmatically with a DIAdem VBScript.  The first step, though, is to import the data you want into the Data Portal.

Let me know where you stand,

Brad Turpin
DIAdem Product Support Engineer
National Instruments