We are under construction!

You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.

Forum Discussion

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

Data Sources
  • MG's avatar
    MG
    Community Manager
    10 days 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?