Can DOMO R or Python help on my request? but I'm not able to find R/Python function...
I'd like to combine 3 type of reports, that is report A, B and C. All of them are daily updated report by the logistics supplier and send to my email as attachments. at the end of month, I will get 30 emails for report A, 30 reports for report B, 30 reports for report C.
I use google script to automatically save the daily attachments in .xlsx onto Google drive files, file A for report A, file B for report B, file C to report C. the google script code is created not by me, I just searched it online and find it workable for my request. I can not adjust and create more code flexibly. I am a google script new hand.
By some certain fields, It is possible to join report A, B, C onto one consolidated report. but this process is manual at the moment.
the question is, can I have the report automatically consolidated by DOMO R / Python script?
because I will use the consolidated report to show dashboard finally on DOMO card. If DOMO can have this kind of coding function, I prefer to use DOMO rather than google script.
I think it should be at ETL there is a script area for me to create code. but I failed to find it pls see the following screenshot.
Best Answers
-
Hi @Lu_zhang ,
If you are inquiring about the location of the Python/R tiles within ETL, it appears that based on the screenshot you provided, you do not have access to them. They should be located under the Scripting section.
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1 -
A Python script is a text file containing Python code, with the extension ".py". If you are not familiar with Python as a language, you can use AI to help you. Obviously, running it from within a Domo tile is most useful for Domo integration.
Running a Python script from a batch file looks like this -Running Python from Visual Code looks like this:
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
I think we need more information about the tables and joins. But it certainly seems like it would be no problem to handle in Python. I have various daily tasks that I perform using Python. My ETLs produce the dataset I need and I use Task Manager and Python to extract them as Excel files to direct paths on our network.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
@ArborRose thank you, and could you pls show me where is the function by detailed?
0 -
Hi @Lu_zhang ,
If you are inquiring about the location of the Python/R tiles within ETL, it appears that based on the screenshot you provided, you do not have access to them. They should be located under the Scripting section.
If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.
1 -
yes, thank you.
I am requesting access to my company DOMO admin. hope I will get access. thank you.
0 -
You do not have to have access to the Python tile to use Python with Domo. In my opinion it is a useful skill to learn. You can install Python on your computer and then create code that works by executing it with a batch file. Or use Visual Code (an interface) to access Python.
If you do use Python outside of Domo, to interact with Domo, you should make sure its running from a server that is stationary. Not on a person computer or laptop that moves about.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
A Python script is a text file containing Python code, with the extension ".py". If you are not familiar with Python as a language, you can use AI to help you. Obviously, running it from within a Domo tile is most useful for Domo integration.
Running a Python script from a batch file looks like this -Running Python from Visual Code looks like this:
** 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.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive