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.
Hi Steven,
Please check your datasource settings. The "data structure type" needs to be "Matrix data".Regards,
TobiasHi Tobias - I already have that set to "Matrix data", but still no luck.
