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.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive