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

johnal67's avatar
johnal67
Contributor
1 year ago

Data Source Loading all rows to an account specified in one cell

Trying to create a Data Source.  I have multiple spreadsheets of the same format with the account name I need to load to in cell B1.  Each .csv file is for a different account that is specified in B1...
Data Sources
MG's avatar
MG
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hi

Are you trying to load Excel spreadsheets or CSV files? I'm not sure I'm clear on the requirements but if you are in Excel can you use excel formulas? Alternatively if you are using CSV files - have you looked at the Stored Text option on the data source dimension?