General keyword search EViews database
Posted: Wed Nov 27, 2019 12:58 pm
Hi,
I'm wondering if it's possible to do a very general database query in EViews?
For example, I would like to be able to use @wquery like this:
My understanding is that I need to specify the first wildcard (*) term, which is typically something like "name" or "description".
The problem with this functionality is that it requires me to know the specific attribute of interest. As a user of a large database with many attributes, I won't necessarily know this information.
For example (hopefully understandable without providing a workfile): let's say my database contains two series called series1 and series2. Series1 has an attribute called "Table.Description" with a value of "Trade Exports Table". Series2 has an attribute called "Statistic" with a value "Exports of Goods". How do I write a general search for "Exports" so that the query returns both series1 and series2? Assume that I do not know the two attributes.
Thanks for the help!
- Graeme
I'm wondering if it's possible to do a very general database query in EViews?
For example, I would like to be able to use @wquery like this:
The key feature of the above code is the first wildcard (*) term in "* matches *Exports*".@wquery("mydb", "* matches *Exports* and freq=Q", "name")
My understanding is that I need to specify the first wildcard (*) term, which is typically something like "name" or "description".
The problem with this functionality is that it requires me to know the specific attribute of interest. As a user of a large database with many attributes, I won't necessarily know this information.
For example (hopefully understandable without providing a workfile): let's say my database contains two series called series1 and series2. Series1 has an attribute called "Table.Description" with a value of "Trade Exports Table". Series2 has an attribute called "Statistic" with a value "Exports of Goods". How do I write a general search for "Exports" so that the query returns both series1 and series2? Assume that I do not know the two attributes.
Thanks for the help!
- Graeme