Forum Discussion

johnal67's avatar
johnal67
Contributor
2 years 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
2 years 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?