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!
Trying to add metadata into database
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Trying to add metadata into database
Your thoughts are the way to go. Fetch into different pages based upon frequency, importattr, then store
Follow us on Twitter @IHSEViews
Re: Trying to add metadata into database
EViews Gareth wrote: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?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Trying to add metadata into database
Use wquery to query the database, then fetch the results.
Follow us on Twitter @IHSEViews
Re: Trying to add metadata into database
Thanks a lot, Gareth. That worked!
Who is online
Users browsing this forum: No registered users and 10 guests