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

psatkar's avatar
psatkar
New Contributor
2 years ago

How to import data in stage via excle template.

Hi All, I need help to importing data to stage via excel template. There is some instruction given in Design Doc https://onestream.mcoutput.com/release_8.1/Content/Design%20and%20Reference/Data%20C...
Data Sources
psatkar's avatar
psatkar
New Contributor
2 years ago

Thanks Marcus,

Ad per the design doc reference, I prepared this file and created Data source and TF rules for this. but not able to import this file. This is not form its a actual data flat file. Is there someting I am missing on ?  

 

 

 

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    2 years ago

    2 things to check:

     - Named range: does it exist, does it cover the lines you want to import including the header, does it begin with XFD

    - Data Source: Allow Dynamic Excel Loads must be True.