importattr command
Posted: Tue Oct 02, 2018 5:44 am
Hi all,
I'm attempting to assign various attribute fields to several series in a data job.
I can successfully import the attribute fields into my workfile as series using this command:
pageload(page=attributes) c:\warem32\cdb_attr.xlsx range="annual!b1:mw20" byrow colhead=0 names=("name", Geography, concept, Product, Unit, "Bank Name(s)", Mnemonic, "Base Period", "Data Edge", "End Date", "Last Update", "Long Label", Real/Nominal, Scale, "Seasonal Adjustmnet", "Series Type", "Short Label", Source, "Start Date", Frequency)
However, when I try to store the attributes in the desired data objects within the same workfile (while overwriting existing attributes) nothing happens.
I am using these commands:
pageselect annual '(the page in which the data objects exist)
importattr(o) attributes @keep all '(I've tried to import just one attribute as well, and still, nothing happens).
Any thoughts on why this code wouldn't work, or if I'm missing something? I've attached the workfile for reference. Thanks,
Bob
I'm attempting to assign various attribute fields to several series in a data job.
I can successfully import the attribute fields into my workfile as series using this command:
pageload(page=attributes) c:\warem32\cdb_attr.xlsx range="annual!b1:mw20" byrow colhead=0 names=("name", Geography, concept, Product, Unit, "Bank Name(s)", Mnemonic, "Base Period", "Data Edge", "End Date", "Last Update", "Long Label", Real/Nominal, Scale, "Seasonal Adjustmnet", "Series Type", "Short Label", Source, "Start Date", Frequency)
However, when I try to store the attributes in the desired data objects within the same workfile (while overwriting existing attributes) nothing happens.
I am using these commands:
pageselect annual '(the page in which the data objects exist)
importattr(o) attributes @keep all '(I've tried to import just one attribute as well, and still, nothing happens).
Any thoughts on why this code wouldn't work, or if I'm missing something? I've attached the workfile for reference. Thanks,
Bob