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
agoralewski
3 years agoCommunity Manager
Fact or Fiction? You can use Excel Import Templates to load data into OneStream via a Workflow
You can use Excel Import Templates to load data into OneStream via a Workflow
Question Credit: Parker Laabs
Is this statement fact or fiction?
Comment your best guess below! Answers will be revealed in two weeks.
* This question is applicable to Platform 7.3.0 and may not be relevant to future releases
7 Replies
Replies have been turned off for this discussion
- NickHymesNew Contributor III
Fact. It can be a data source.
nick
archetype consulting
- BenThompsonNew Contributor III
Fact
- NicolasArgenteValued Contributor
- RamuVNew Contributor III
Fact!
We can definitely use the Excel templates to load data to OneStream.
The templates can be used to Merge or Replace.
A frequent template I use is for People Planning adhoc loads.
- ShereenLaviNew Contributor III
How are you accomplishing this?
- NicolasArgenteValued Contributor
HI Shereen! You would use the excel with a specific Name range : XFD. Please have a look at the design doc and I suggest that you look at the Navigator trainings on that matter.
CHeers
- agoralewskiCommunity Manager
Fact!
Ensure the Data Source ‘Allow Dynamic Excel Loads’ is set to True to import Excel data to the Stage. OneStream will look for any named ranges in the file.
Related Content
- 2 years ago
- 2 years ago
- 4 months ago