EViews.com

Hi,

I'm trying to add some metadata into all the series in a database. I know there is this useful command known as importattr. However, that only works for objects in a workfile.

Therefore my logic is that I fetch the objects from the database and then import the metadata from my excel file (columns are separated into individual alpha series eg units, source...) and while having another alpha series, name, which contains all the names of the objects in the database. After all this, I would use importattr to add the new attributes in.

My problem is, the database objects are all in different frequencies and workfiles (or pages to be specific) needs to have all objects in the same frequency. Is there a way to work around this?
I was thinking along the lines of fetching objects based on their frequencies to different pages with different frequencies but I don't think it's possible.

Thanks!

Your thoughts are the way to go. Fetch into different pages based upon frequency, importattr, then store

Your thoughts are the way to go. Fetch into different pages based upon frequency, importattr, then store

Thanks for the reassurance. But now I'm wondering how do I fetch from the data base based on frequency? Is there a frequency option/feature in the fetch command? Or do I have to do some preliminary steps before fetching?

Use wquery to query the database, then fetch the results.

Thanks a lot, Gareth. That worked!