How to import sheet name or file name as a datapoint? (Dropbox advanced file connector)

Hi Team,

My source data is in csv's where one of the datapoints is embedded in the file name and the worksheet name. Is there a way to import that datapoint into domo?

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    On some connectors, in the configuration settings, there is the option to include the file name as a column.

    If you have this option on the dropbox connector, select that and then you can use the formula tile in Magic ETL to extract the information you need.

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • tejusarora
    tejusarora ⚪️
    edited April 28

    Hi Mark, I don't believe that's an option with Dropbox. What data source do you use? @MarkSnodgrass

  • GrantSmith
    GrantSmith Indiana 🥷

    There should be a _BATCH_FILENAME_ field in your dataset after the connector runs which will contain the name of the file which was imported into Domo. You could then use an ETL to extract information from your filename that way.



    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**
  • The _BATCH_FILENAME_  only takes the parameter part. For instance, if the parameter is File Name Starts with America, then the _BATCH_FILENAME_  will only show America. I have a report with date in the column name such as America_0101202, and the date changes with the report.

    Is there a way to import these?


    Best,

    TJ