Skip to main content
J
johnal67
Contributor
November 20, 2024

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

  • November 20, 2024
  • 1 reply
  • 0 views

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.  How can I make all subsequent rows use the account is in that one cell B1 on each spreadsheet?

1 reply

M
OneStream Employee
MG3OneStream Employee
OneStream Employee
November 25, 2024

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?

 
Terms & ConditionsAccessibility statement