The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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
4 years ago

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