search

IRIS-Solutions-Team / IRIS-Toolbox

[IrisToolbox] for Macroeconomic Modeling
Other
92 stars 42 forks source link

Question about databank.fromSheet() #373

Open tosapola opened 1 year ago

tosapola commented 1 year ago

Hi,

I'm loading a simple Excel file with some single-frequency data. Do we always have to put a frequency quantifier (i.e. __quarterly__) in first cell? Without that, it seems to be a problem now.

Unrecognized function or variable 'freq'.

Error in Tabular/toDatabank (line 269)
                values = extractValuesColumn(this, column, freq);

Error in databank.fromSheet (line 115)
        outputDb = databank.merge("warning", outputDb, toDatabank(tabularObj));

Error in run_HLW (line 4)
d = databank.fromSheet("LW_DB_v3.xlsx",sheet="Data");

Best, Tos

jaromir-benes commented 1 year ago

Yes, that needs to be always included. On the plus side, you can have multiple blocks of data, each with a different date frequency included in one file.

Best J

On Fri, Apr 21, 2023, 5:51 AM tosapola @.***> wrote:

Hi,

I'm loading a simple Excel file with some single-frequency data. Do we always have to put a frequency quantifier (i.e. quarterly) in first cell? Without that, it seems to be a problem now.

Unrecognized function or variable 'freq'.

Error in Tabular/toDatabank (line 269) values = extractValuesColumn(this, column, freq);

Error in databank.fromSheet (line 115) outputDb = databank.merge("warning", outputDb, toDatabank(tabularObj));

Error in run_HLW (line 4) d = databank.fromSheet("LW_DB_v3.xlsx",sheet="Data");

Best, Tos

— Reply to this email directly, view it on GitHub https://github.com/IRIS-Solutions-Team/IRIS-Toolbox/issues/373, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGCVKKVXYFR76LJYMOSN5J3XCH74LANCNFSM6AAAAAAXGKPRWE . You are receiving this because you are subscribed to this thread.Message ID: @.***>