-
ETL Process to Analyze Google Reviews and Generate Automated Replies
Hi everyone, I’m exploring adding a step to an ETL process to analyze Google review data and generate recommended responses using ChatGPT or a similar tool. Currently, I have a Zapier connection set up, but it’s unreliable and inconsistent. Here’s what I’m looking to achieve: Dataset Input: I have a dataset of Google…
-
Is there any way to bring/read PDF files in their original format to domo from SharePoint folder?
I have a use case where I have to bring folder access from sharepoint to domo. When I access them they get converted to other file types. However I want the access to be in PDF format only and later would like to run a python script in Magic ETL to extract specific data from pdfs to update rows in Microsoft excel. Is there…
-
How can I set up a graph to show period over period data in a dynamic way?
I am looking for a way to show a bar graph with sales data by period and a growth rate line with period over period percent change. I have a detailed dataset with a large amount of sales data spanning over multiple years. I am having trouble with how to get the prior period data to be on the same line and to be dynamic so…
-
Multiple results encountered for the same location in Pivot Table indicated by ****
Attached is a sample of my data. I am trying to create a pivot table with the following: Rows: location, week, date, shift Columns: count(unique identifier), count(unique identifier) * shift length In my ETL, I created a formula to handle empty values. It determines whether a shift was 8 hours or 10 hours, based on a…
-
How to shift first week of year from December to January?
The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced…
-
How to create WoW, MoM, QoQ, YoY dimensions to put into variable?
I want to create a dimensional variable that allows users to choose between WoW, MoM, QoQ, and YoY using the chart types below. What is the best way to go about this? Any tips on creating the ETL to create the components above?
-
Magic ETL Possibility?
Hi, I'm having an issue. I want to split the fruit column by comma then alphabetize, then bring them back together on their respective account ID. How would I do that in magicETL?
-
Best Practice - Columns to Rows?
Community, My data is formatted per my example screenshot below. Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows? I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)
-
How to show events that happened after a selected one?
Hello, How can I show all events individuals have attended after they attended a specific one selected by the dashboard user? Ex. Out of the 200 who attended Conference A in January '24, 100 people attended Conference B in February, 80 Conference C in March, and 110 Conference D in April. I want to show the B, C, D…
-
Any way to filter a column by data type?
I am working with a data set that has multiple contributors. Unfortunately many of them enter data their own way. Specifically, I am looking at Diabetic A1C data. One person might enter it is as 5.765, another 5.76%, yet another 5.764444E3, and then another would enter something as 93 MG/L. Is there any formula or DOMO…
-
Solution Share: Using Python to Bulk Rename Columns and Convert Timestamps
Hey Domo Fam! Wanted to share a success story using Magic ETL + Python scripting to solve a problem. My first use of a python tile! Challenge I'm building a Company Dimension table using Hubspot company data...all connector reports have technical column names (over 450 columns) and all date fields (50+ columns) are a mix…
-
Re-"Start"-ing inactive datasets in bulk from the Datacenter Dataset View
When datasets haven't been actively queried in a while, they get auto-disabled, and need to be manually "re-started". When datasets like that are inputs to dataflows, they disable the associated dataflows. But, from the Datasets view of the Datacenter, we have no way of seeing that a dataset needs to be "restarted". It…
-
Transforming an ETL
Hello! I am trying to edit an ETL with three input datasets.. My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset. Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'. The request I received was to add a column onto one of our cards…
-
How can I remove these multiples?
Hello, I have a Magic ETL that provides open order data based on an item number. One issue I am facing is if I have two or more types of open orders for an item, then they will cross multiply. For reference, I have 3 open internal requisitions and 3 open sales orders for 1 item. Instead of displaying 6 rows (3 IR and 3…
-
Export Magic ETL Code for External Version Control
In our current environment, we use an external repository (Bitbucket) to maintain version control and the ability to run detailed diffs before making changes to our SQL dataflows. It would be helpful to have a way to export either the code or some representation of the current state of a Magic ETL dataflow to be used in…
-
error while converting text to integer/float
I have a column that is a text column has values in %, $ and -ve values as well. I tried replacing the % ,',' and '$' to have only numeric values to convert it into a float or integer column. However I am getting the below error. What can I do to convert the numbers into numeric column so that I can apply calculations to…
-
Create Month End Date column with Year & Month columns?
My dataset has a Year & Month columns, I would like to add a 'Month End Date' Date column into this dataset with magic ETL. But each month has different end date so I'm not sure how to go on about this
-
Any Function to decode UTF-8 characters available in Domo?
Hi, I have a URL field in my dataset where the data in certain rows have UTF-8 characters instead of normal html characters… For example…. https://www.theverge.com/2024/11/26/24306815/google-gemini-spotify-extension-rollout-android is showing up as…
-
Removing Dataset Outputs from Magic ETL
We have been cleaning up our Domo instance removing unnecessary outputs from Magic ETL flows. I am assuming these datasets aren't truly being deleted, just disconnected from their source to not get updated any more. Is there a way to find these "orphaned" outputs so that they can be properly deleted?
-
Converting a duration time text field into a number
I have a field from NetSuite called duration, which is a measure of time in this format 8:30 This stands for 8 hours and 30 minutes of work time. I need to convert it from a text to a number so I can create measure. Thank you! Jayme K.
-
Validating datasets that has different formats
I need to validate 2 finance datasets to ensure the numbers match for all GL accounts. Dataset A: Columns: Account_name, Branch_id, MTD, MTD Budget, MTD Last Year, YTD, YTD Budget, YTD Last Year. This dataset is generated monthly from the ERP system, with pre-calculated values. I need to append it each month after adding…
-
Group By Issue
I need assistance with identifying transactions that net out to zero in a large dataset. Each row in the dataset represents a unique transaction with its own ID. Objective: Identify pairs of transactions that meet the following conditions: Same client ID Same transaction type ID Same transaction date The sum of their…
-
Magic ETL: EJ Group
In this quick tutorial, I share how to convert Redshift queries into Magic ETL with a single click. I demonstrate how to seamlessly transition complex SQL code into Domo’s intuitive ETL tiles, with minimal adjustments. This tool has significantly streamlined our workflows, reducing Redshift processes from 89 to just 27—an…
-
Magic ETL: Butler AR
Unlike other tools I've used, Domo makes it easy to combine data from various sources—SQL databases, Excel sheets, APIs—and transform it to deliver relevant insights. This feature has been invaluable for providing the exact answers my team needs to drive company decisions efficiently. Use case
-
Connectors - Enhance Scheduling
Currently, the scheduling capability with respect to Connectors is based solely upon UTC (see first screenshot below). The scheduling capability available with respect to Magic ETL 2.0, however, provides the user flexibility to specify timezone (see second screenshot below). Can the scheduling capability with respect to…
-
MagicETL Transform Settings: Timestamp to Date
I can't seem to find a clear answer as to what is happening here, so I'm turning to the community. I have a dataset with a timestamp field, createdAt The dataset arrives to Domo in UTC, and my company timezone settings are converting it to USA\Eastern Time. This is working as expected. Using this as an input dataset in…
-
Input DataSet - Load New data
I am working on a new dataflow using Magic ETL. I have 11 input datasets. All are Workbench jobs with the Update method set to Append and they each have an assigned Upsert Key. I have configured each of the inputs to load New data. When I save my dataflow 3 of the 11 throw an error. "This data set does not support data…
-
Group two datasets and join them
I have two excel files one includes sales data and line items of products sold in each invoice, the other sheet I have is the freight charges per invoice. I want to be able to sum the freight and sales totals on both sheets and group them by the invoice number on a combined sheet. Is this possible? I sort of started with…
-
Case when and formula with date
I'm writing the following formula and it's not distinguishing between the dates correctly. What am I doing wrong? case when `Parent OR AgencyName` = 'Aspire Home Healthcare' and `Date` >= '10/23/2024' then `Total referrals` = 0 ELSE `Total referrals` end Note, my date shows as the little calendar and 'Total referrals'…