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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive