Query multiple TDMS Files

[aSquared]

Hi,

I would like to evaluate the option of using TDMS files instead of an SQL database.

I will need to simply extract/query results that follow some conditions from multiple TDMS files.

I found many articles but could not find one example of how to extract data from multiple tdms files.

Should I have Data Finder or DIADEM ? or can I simply use LabVIEW ?

I am attaching a simple VI that generates 50 TDMS files (at the same folder as the VI), with "random" properties ('Title' and 'Type') and "random" data colums ('Temperature', 'Channel', 'Power').

Save the VI in a new folder and Run it. it will generate 50 TDMS files (see block diagram).

Now, considering those files, (for example) how can one extract only the the data where Test='Test2'  and Type='Type1' and (Temperature=25 or Power>0.4) ?

Amitai.

[crossrulz]

You want to use DataFinder.  You can then use LabVIEW to do a querry through the DataFinder.  I'm sure there are examples floating around in the LabVIEW Example Finder.

[aSquared]

Hi crossrulz and thanks for replying,

I will look around to find some example or webcast.

I wonder if the Data Finder is included in LabVIEW Developers Suite...

Amitai

[crossrulz]

I'm pretty sure it is included with the Professional.  I'm not sure about the other versions of LabVIEW.  If you install LabVIEW with your current license and it is installed, you are good to go.

[Hooovahh]

The DataFinder toolkit is awesome when dealing with TDMS report indexing.  Lots of good stuff can be done with report look ups.  Find me a report that was made after this date, before this date, made on this PC, running this version of software, for a UUT ran in this nest location, with this operator name, that failed.  Queries like that can be made very easily once the indexing is complete.

As for pricing.  It is included with the developer suite, but I'm pretty sure it isn't included with any professional, or full package.  If you go to a page like the PID Fuzzy Logic Toolkit you'll see in bold at the top it says it is included with Full and Professional.

The DataFinder page doesn't have this.

Oh and there are several examples found in the Example Finder.  Download a trial and see if it is worth it.

[crossrulz]

---

@Hooovahh wrote:

The DataFinder toolkit is awesome when dealing with TDMS report indexing.  Lots of good stuff can be done with report look ups.  Find me a report that was made after this date, before this date, made on this PC, running this version of software, for a UUT ran in this nest location, with this operator name, that failed.  Queries like that can be made very easily once the indexing is complete.

As for pricing.  It is included with the developer suite, but I'm pretty sure it isn't included with any professional, or full package.  If you go to a page like the PID Fuzzy Logic Toolkit you'll see in bold at the top it says it is included with Full and Professional.

The DataFinder page doesn't have this.

Oh and there are several examples found in the Example Finder.  Download a trial and see if it is worth it.

---

According to here, the DataFinder Toolkit is an add-on that is included in the Developer Suite.  So it looks like Hooovahh is correct.

[crossrulz]

---

aSquared wrote:

I found many articles but could not find one example of how to extract data from multiple tdms files.

Should I have Data Finder or DIADEM ? or can I simply use LabVIEW ?.

---

By the way, DIAdem uses the DataFinder for its querrying.  But I think you will need the DataFinder Toolkit in order to perform the querries in LabVIEW.