-
Joinin on Email
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
-
Split Column by Number of Characters
Can we add an option to split a column by the number of characters in the field? I.e. split column by number of characters as far left or as far right. This is a very useful feature in PBI Power Query Editor especially when you have strange date formats like 1231201 or concatenated fields with an order number of a specific…
-
Rank Tile Not Grouping, Needs Case Sensitive box
I am using the Rank tile, ordering on a Timestamp and the column that makes up a partition is Customer. For example, I have "CUSTOMER A" and "Customer A." These are in the raw data and represent different clients, but the Rank is treating them as the same. I will probably value map one of variations to be unique, and I'll…
-
Rank and Window? Lag?
So I have a dataset that captures quarterly expense data. I have been tasked with adding an 'expense ratio change column' Basically, I need to know the % change of expenses changed from quarter to quarter by project I know the math on this ((p2 - p1) / (p1)) but am not sure how to tile it in domo to make sure it is taking…
-
How to mix and match Data
Number City 1000 A 1100 B 1200 C 1300 D E 1400 1500 F 1300 Hi Folks, Need your help pls. 2 Questions - 1) In the table above, you could see that 1300 is mapped to city 'D' but in last row it is blank. How do I map it using beast mode or Magic ETL to fill by Lookup in the same column. Req: Lookup in 'Number' and fill Blanks…
-
Does a slicer work even if I'm using a sub dataset?
Hello. Hope someone can enlighten me or help me if there's a solution for this: I need to use one slicer for my dashboard, which contains like 16 cards. The slicer should be able to filter all cards in that dashboard. Here's my problem: I'm using three datasets for the cards in the dashboard: Main Dataset - let's name this…
-
Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it. Thanks in advance!
-
Weighted Average Calculation
Hi, I'm working with a dataset and am wanting to make sure I am going to get a weighted average of our mortgage rates. We have loans that range from 100k-400k and each loan has an associated mortgage rate. As an example, we have two loans that go into the same security that are 5% and 5.5% Loan A is worth 200k and loan B…
-
Where can I find the Description when you save a dataflow
I would like to create a card showing the changes to dataflows and the description. I have looked in domo stats and also domo governance and dont see it. I am looking for the comment you add before you save. Not the description of the dataflow that you put along with the title.
-
Add Notes and Titled Containers to ETLs
I find that my ETLs are often big, with multiple endpoints; so when I come back it takes me some time to catch up with what I did. I think that adding some text notes to the ETL view would make it easier to evaluate what I, or one of my coworkers, have done. As for titled containers, they would allow a user to draw a…
-
Combine tables using ETL inner join
Hi everyone, I'm trying to combine two federated tables using the inner join in Magic ETL. Both tables have over 9.5M rows but when I join them, the result is only 87K. I tested the join in Snowflake and it resulted in 9.5M by the logic: SELECT * FROM 'A' INNER JOIN 'B' ON A.X = B.X What could i be doing wrong? *I'll need…
-
Add Dataflow Comment to Domo Stats | Domo Governance
I would like to create a card showing the changes to dataflows and the description. I have looked in domo stats and also domo governance and don't see it. I am looking for the comment you add before you save. Not the description of the dataflow that you put along with the title.
-
Append Output dataset help
Hello all, I have an Magic ETL (A) that with a output dataset - say OUTPUT_1. What I am looking for, is when every time I run the ETL, I need the output results to be appended. At the same time it should not create duplicate records. I created a new Magic ETL (B) with this OUTPUT_1 as input dataset and outputted to…
-
Question on Domo SQL syntax
Hello all, I am trying to do Magic Transform using SQL option. I have embedded a SQL query but it is erring as it is not compatible with Domo syntax. Appreciate your help in this regard. DATE_PART('WEEK',CAST(TO_CHAR(TO_DATE(TO_CHAR(PRODUCT_KEY),'YYYYMMDD'),'YYYY-MM-DD') AS DATE)) AS "SaleWeek",…
-
Need help mimicking recursion with partitioned datasets
I need help implementing a particular use case for partitions: importing selected partitions from a dataset, modifying the records, then outputting the data back into it's original partition (or a new partition) in the original dataset. There are two uses for this I can think of off the bat: A dataset can have a maximum of…
-
Aggregate and ETL question
Hello all, I have the below workflow in my Magic ETL. Just posting a sample version below. My question is - I have a ProductID that I join from both the data sources and then do a group by and output to a file. But I also need to know Total count of Product ID or row count from TEST spreadsheet source. Is there a way I…
-
How to count status changes in snapshot data
I have data that I snapshot daily. It has employee name and employee status. Once the status gets updated, it remains that way: ex for one employee: 1/1 Name: active 1/2 Name: active 1/3 Name: active 1/4 Name: Inactive 1/5 Name: Inactive 1/6 Name: Inactive 1/7: Name: Inactive At the card level, I would like to be able to…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
How to input identifiers using identifiers
I have a data flow that has multiple properties and competitors. I was looking for a way to label all of the records that are in between into one property. In the example sheet that i uploaded, I was wondering if a beast mode formula could be used to rows 3-16 are labeled as the property Brandon crossroads in this case.…
-
Sum column when i have duplicates in other two columns?
I have these columns and I would like to sum the cost column only when the Publication and Year column have duplicates, so I can see the cost per Publication per year. Brain fart, I am assuming this is pretty straight forward? I'd like to do it in ETL if possible. Is there some SQL I can utilize to do this in the formula…
-
What function will help me determine a variable part of text?
I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column. Question is how do I write a Case formula that will return True or False based on the contents of another column? For example, the word "Delivery" is placed in different locations on a string…
-
Date format question
Hello all, I have a snowflake i/p data source. One of a column is a date field and it showing up as floating decimal in Domo. This field has value -3 (even in data source) if it is a null else it is a date.. As this is floating decimal type in domo, under configuration I changed to Date type. When I try to join with…
-
GA4 campaign and session campaign data Joining question
I have a unique question… some context: I have a dataset from the Google Analytics 4 connector that has 5 columns that I am grouping by with one of those group by columns being the 'campaign' dimension. The other dataset in the join has 4 of the same columns but the fifth one is a 'session campaign'. The two datasets are…
-
How is Timezone inherited from source then converted?
I have a dataset coming in from the Gong connector and some timestamps come in as text fields (scheduled, started). Our Domo timezone is set to Eastern. When I cast data type as timestamp, the times move up 3 hours. Should I assume the Gong source data is Pacific (Gong is in SF) and Domo is inheriting the timezone…
-
I want to create a column that contains the total sum of another column.
Hi everyone, looking to create a column that contains total revenue in order to find individual contributions. I have tried to do this using rank/window function within the magic ETL however all I get is a running total. Any help appreciated :) Thanks!
-
Error Message on Run when Using 'New' Data Selection
Hi all, I have an ETL with a View of a Dataflow as the input - data selection on input set to 'New' (Beta) then output is set to 'Append (Beta'). The input dataset is 250m rows going back 13 months, so I really only need the ETL to run on the latest transactions coming into the input, not on the whole thing. When I hit…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Multi-tab input
Hello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to import that to Domo. When I am using this in Magic-ETL, I am unable to specify the tab that I need.. What is the way to specify the exact tab I referring to in that spreadsheet. I need to use different tabs for different joins in…