Can DOMO R or Python help on my request? but I'm not able to find R/Python function...

Lu_zhang · 2024-07-08T03:18:50+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

Manasi_Panov

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.

ArborRose

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:

All comments

ArborRose

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.

MichelleH

@Lu_zhang ETL has Scripting Tiles that you could use to code R and Python within Domo, though your access depends on your instance's subscription.

Here is an article about these tiles: https://domo-support.domo.com/s/article/360045485833?language=en_US

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/97055#Comment_97055

@ArborRose thank you, and could you pls show me where is the function by detailed?

Manasi_Panov

Hi @Lu_zhang ,

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/97074#Comment_97074

yes, thank you.

I am requesting access to my company DOMO admin. hope I will get access. thank you.

ArborRose

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.

ArborRose

Running Python from Visual Code looks like this: