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 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]
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.
Hi Steve,
I think the file loaded to OneStream might be the issue. It is not readable as it might be an XML file.
Can you send me the file you try to load into OS? Please change the metadata/data you do not want me to see, but do not change the structure of the file itself. nicolas.argente AT sonum-int D0t Com