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
Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

Hi Steven !

In the standard demo, you can find such configuration with the "HoustonBudget" source file, I hope it will help you:

 

Regards,

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

    Hi Sergey - I did check the Golfstream app for ideas first and did use as a baseline. This example uses a flat file vs. an Excel (xls/xlsx) file correct? So for the Time periods, I can see they're setting it to a certain length based on the month. However, in the Excel template I'm trying to load, I can't do that because when you upload the Excel file to preview, it's all encoded. 

    Happy to send an email to Partner Enablement if it's easier to have someone jump on a quick call. 

    Thanks,

    Steven