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

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

Tobias's avatar
Tobias
New Contributor III
3 years ago

Hi Steven,
Please check your datasource settings. The "data structure type" needs to be "Matrix data".

Regards,
Tobias

  • SxD's avatar
    SxD
    New Contributor III
    3 years ago

    Hi Tobias - I already have that set to "Matrix data", but still no luck.