Hello! I'm trying to find the issue in my current python code that iterates through each date while maintaining a set of already logged accounts and then counting new accounts each day. I have sorted by the 'Close Date' , grouped by the 'Close Date' and the 'Owner Division', and have 'new accounts' and 'seen_accounts'…
Domo's use of mySQL as an ETL is frustrating slow. I have a solution that runs in seconds when I duplicate it in MS SQL, but when applied in Domo it takes forever. I need to figure out how to do the following with tiles in Magic ETL. I have created an example using store locations as anonymized data. Assume I have a table…
I am using a Python script to split multi value cells into separate rows, The script was working fine for a few days and now it fails, anything I should look into checking ? Import the domomagic package into the scriptfrom domomagic import * import pandas as pd read data from inputs into a data frameinput1 =…
Hello, when attempting to import and use the vader module, I'm getting an error from nltk package saying I need to download 'vader_lexicon' This feels super basic so I'm sure I'm just doing something wrong. Any thoughts on what else to try?
ValueError: domomagic: Array dict keys must be non-empty strings I have tried the code on both the VS code and jupyter notebook its working on them. What might be the problems coz its giving me the above error.
We would like to use data of a dataset in the body of a POST request and we were wondering if the Python Script tile in Magic ETL would work for that. We have analyzed but it does not seem to have libraries for that. We have this solution to export the dataset and make the request in a Python script in a Virtual Machine…
Domo python tile fails to write the pivoted dataframe with pd.pivot_table if it has nulls while converting - even if you add 'fill_value=np.nan'. See below: The pivot function works perfectly fine - it does generate the df, however, when you try to write it, it fails - see below if I write the unpivoted df, it works fine…
Greetings Domo Community, I have currently been refactoring Magic ETL tiles and have been attempting to use Python and R scripts to test for equality before finalizing the refactored tile components. Using both approaches with Python and R I have had significant difficulties in completing this task, which I will outline…
I have been handed an r script that has is using an accessToken to connect to domo and extract a dataset using a dataset ID. My end goal is to translate this to Python, as I have an existing pipeline in python that needs this dataset. Initially using the naive approach I tried to connect to Domo using pyDomo but was…
I am using the Domo Dimensions Calendar as an input to a Python script that updates an dataset of the next 365 days as columns |2023-01-27 | 2023-01-28 | 2023-01-29 | 2023-01-30 | ........ | 2024-01-27 So, when the script runs tomorrow the first column will be 2023-01-28, and so on. It works, to a point. The first daily…
It looks like you're new here. Sign in or register to get started.