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
-
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.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Hi Mark, I don't believe that's an option with Dropbox. What data source do you use? @MarkSnodgrass
0 -
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!**0 -
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
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive