Search found 5 matches

by jtb35962
Tue Jan 10, 2017 2:29 pm
Forum: Data Manipulation
Topic: Importing attributes from excel
Replies: 7
Views: 5642

Re: Importing attributes from excel

Thank you very much. This looks like it is working and I should be able to replicate this code easily to other properly formatted excel files.
I will send a test file to the data group soon. I think this is what they are hoping to receive.
Thank you again!
by jtb35962
Tue Jan 10, 2017 12:16 pm
Forum: Data Manipulation
Topic: Importing attributes from excel
Replies: 7
Views: 5642

Re: Importing attributes from excel

I update these and others monthly and even more series quarterly, so I need to replicate the process regularly and on a large scale.
They key is replicating something similar to Aremos banks that data can digest. Mnemonics, data update and other attributes updated.
Thanks
by jtb35962
Tue Jan 10, 2017 12:08 pm
Forum: Data Manipulation
Topic: Importing attributes from excel
Replies: 7
Views: 5642

Re: Importing attributes from excel

I have included a test file and the associated excel. I am not sure that the excel is set up correctly, but it is a start.
Thanks
by jtb35962
Tue Jan 10, 2017 11:27 am
Forum: Data Manipulation
Topic: Importing attributes from excel
Replies: 7
Views: 5642

Re: Importing attributes from excel

Should I provide an example file instead? This is for making databank updates for IHS markit.
by jtb35962
Tue Jan 10, 2017 11:16 am
Forum: Data Manipulation
Topic: Importing attributes from excel
Replies: 7
Views: 5642

Importing attributes from excel

I am attempting to import attributes from Excel. I read that it is possible using importattr, but upon cursory attempts from reading the help options after importing a second work file with potential attributes, I cannot correctly use the command box make it work. This is likely do to my inexperienc...

Go to advanced search