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...
Forum Discussion
Hi Steven,
Please can you check the title of the columns.
I would say, for testing purposes, please try to simplify this naming. (ie. Try only with this format for now : T#[2021M1]) Then do not forget that you need to map all the members in Transformation too. (ie 2021M1 to 2021M1). That should work... and only then you compexify.
PS: Thanks with a kudos point 🙂
Hi Nicolas,
If I make the value just T#[2021M1] then I get an error saying it's missing an amount column.
Steven
Hi Steve,
Here is a sample picture. Double check that time dim is in your transformation.
If you still get the same error, please try with only one column : January. Change your datasource accordingly and try to see if you can load. Error could be in the amount column and that would be a way to double check.
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.
- You need an amount column in excel even empty
- The time dim should follow this format in the excel T#:[]:[]:[2020M1]