how to pickup elements that in a channel to form different new channels?

[100176]

Hi, all,

     I am quite new to the NIAdem, and i am using the demo version of 10. Here the situation is we get test results from an automatically formatted files, all the results stay in a channel, but they belong to different test cases, for example:  element 1-4, 8-10, 20-23 belong to test1, and 5-7, 11-15 belong to test2, ....  and thousands of datas in this channel, and I would like to pick values that belong to different tests, and form the new channel, then it would be fine to deal with them.

    What's more, i guess, VBS need to be used in this case, but do not know where to start, though in the SW help, i saw some information, but still do not know how to write my own scripts, any reply will be appreciated.  Thanks!

seven 

[Brad_Turpin]

Hi seven,

My guess is that the best way to solve this is with a DataPlugin which reorganizes your data file while it is being loaded into DIAdem.  Please reply and attach a sample data file and explain in detail how to tell which rows belong to which tests.  I will look at it and see if I can create a DataPlugin for you, if it's not to difficult.

Are your original data files ASCII files?  If so, please send me the original ASCII file, not the TDM file that DIAdem would export once your ASCII data is already loaded in.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[100176]

Hi, Brad

My original data files are 'access 2000 files format', and here is a sample data file. in sheet 1 you can see the measurement ID and results, in sheet 2 you can see measurement

iD and corresponding measurement name, i want to pick all the test resilts that belong to 'output power ' and form a new channel. thanks for your help.

Seven

[Brad_Turpin]

Hi Seven,

If your original data files are ACCESS data base *.mdb files, and you want to load the records WHERE (MEASUREMENT_NAME='Output Power') into a DIAdem channel in the Data Portal, then what you really want to do is execute an SQL query to load that data into DIAdem.  You can do this by creating your own VBScript, or you can use the below attached "SQL Wizard" application with its dialog approach to select your table, column(s), and build your conditions, then load the data into DIAdem channels the way you want to have them.

You will need to replace lines 9 - 11 in the "SQL Wizard.VBS" with similar lines that point to your *.mdb files instead of the sample *.mdb files that are included in the ZIP file.

Brad Turpin
Product Support Engineer
National Instruments