2 Obstacles to Achieving Automated Reporting - asking for help
3PL send me daily storage data. In the file each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report with each day's data in different sheet.
I'd like to connect this daily data file with a DOMO designed card to automatically append data to the card.
I have two difficulties:
- how to distinguish data from different date? In DOMO, by appending data, it will accumulate each day's data without DATE distinguished. Now I think I can achieve it by VBA. Can I achieve it by some DOMO functions?
- how to append data with the smallest manual workload?
thank you.
Best Answers
-
I would recommend setting up an ETL with a file upload dataset as an input. You can then in this ETL use the "Add Formula" tile to grab the current date.
Once you execute the ETL once, you can go back in and use the output as an input and append to create a recursive data flow. For example.
Then you'll be able to load the current days data into the excel file connector dataset, which will then kickoff your ETL that will add a column with the current timestamp and append to your master dataset.
Example output
A few things to note. You'll want to make sure your columns are consistent so the append will work as expected. There are other options, such as the email connector, or SFTP depending on how exactly you receive your data.
Let me know if you have any questions!
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1 -
One way you could do it would be to append to a dataset using an ETL.
Create a dataset and make sure it has a column to store the date. In the ETL dataflow, set a formula value with the current date and that in the date column within the dataset. Use the "append" tile to append data each day, the column value will act as a timestamp.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
I would recommend setting up an ETL with a file upload dataset as an input. You can then in this ETL use the "Add Formula" tile to grab the current date.
Once you execute the ETL once, you can go back in and use the output as an input and append to create a recursive data flow. For example.
Then you'll be able to load the current days data into the excel file connector dataset, which will then kickoff your ETL that will add a column with the current timestamp and append to your master dataset.
Example output
A few things to note. You'll want to make sure your columns are consistent so the append will work as expected. There are other options, such as the email connector, or SFTP depending on how exactly you receive your data.
Let me know if you have any questions!
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**1 -
One way you could do it would be to append to a dataset using an ETL.
Create a dataset and make sure it has a column to store the date. In the ETL dataflow, set a formula value with the current date and that in the date column within the dataset. Use the "append" tile to append data each day, the column value will act as a timestamp.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive