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
SxD's avatar
SxD
New Contributor III
4 years ago

The part that I'm hung up on is all these examples are using a flat file (.txt, .csv, etc.) where you can either specify which column or start/end position. Thus, there's no way for me to tell OS that column x is my Time and Amount dim. This is my current setup and the way I know it works to load an XFD template, unsure if I can set it up as a Delimited File vs. Fixed File though, so I can try that. I tried with just one month on my last test and got the same error. 

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.