Forum Discussion

Tobias's avatar
Tobias
New Contributor III
4 years ago

Import TextValue from Matrix-Excel

Hi, I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary. As I have to change the vi...
Import
NicolasArgente's avatar
NicolasArgente
Valued Contributor
4 years ago
  1. You need an amount column in excel even empty
  2. The time dim should follow this format in the excel T#:[]:[]:[2020M1]
SxD's avatar
SxD
New Contributor III
4 years ago

Thanks Nicolas! Your suggestions were spot on and I was able to load data from the XFD Excel template. Hope this helps others in the future too.