Automatic update of a workfile based on Excel files
Posted: Fri Feb 02, 2024 2:57 am
Hi,
I created a program to import some series from an Excel file.
Basically, the import code is built that way:
import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector","Sector","Last Updated","Index","Description") na="#N/A" @freq M @id @date(earliest_top) @destid @date @smpl @all
It works but when I open the workfile and refresh the series (automatic update), I get this error message: "EARLIEST_TOP is not defined in "IMPORT(MODE=UO)"
How can I solve this issue ?
Regards
I created a program to import some series from an Excel file.
Basically, the import code is built that way:
import(link) \\intra\partages\FOLDER\PMI_ALL_manuf.xlsx range="Monthly PMIs" colhead=8 namepos=custom colheadnames=(,"Name","Geography","Major Sector","Sector","Last Updated","Index","Description") na="#N/A" @freq M @id @date(earliest_top) @destid @date @smpl @all
It works but when I open the workfile and refresh the series (automatic update), I get this error message: "EARLIEST_TOP is not defined in "IMPORT(MODE=UO)"
How can I solve this issue ?
Regards