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
Sorry to reopen this thread, but I have a similar question on a Matrix Excel Template load. Can you load an Excel Template file to the Import staging table with multiple columns as the time period with the amounts in each of them? I'm running into an error where it's looking for an Amount and Time column separately. Perhaps I don't have my Data Source setup properly? This is what my template looks like for the amounts:
If I need to start a new thread, please let me know.
Thanks,
Steven
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.