Any way to automagically strip of the first 16 rows of a csv file in order to automate the ETL ?
Hi dojomaniacs!
i've got a scheduled export from an operational tool that is being emailed to a box account to be picked up by Domo Box connector and manipulated/ETLd from there.
Is there a function to strip off extraneous header rows from an incoming file?
There's not a way to exclude them from the generated export.
thanks much!
amy
Best Answer
-
The ability to specify that a file's data and header rows start a few rows down is a common trait many of the connectors share. I don't think the regular Box connector is one of them, but there is an Advanced Box connector that does let you do this. Do you see that connector in your list of available connectors? If you don't contact your Domo rep or support.
With DCM reports like this you have to be somewhat careful to not add any more filters unless you also update the header and data rows in the connector. Learn from my past mistakes on that.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
The ability to specify that a file's data and header rows start a few rows down is a common trait many of the connectors share. I don't think the regular Box connector is one of them, but there is an Advanced Box connector that does let you do this. Do you see that connector in your list of available connectors? If you don't contact your Domo rep or support.
With DCM reports like this you have to be somewhat careful to not add any more filters unless you also update the header and data rows in the connector. Learn from my past mistakes on that.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
works perfectly - thank you, Aaron!
2
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