-
WriteBack duplicating datasets
When using the the writeback option in Magic ETL Why does it duplicate the dataset . example below we now have 2 outputs identical. since Domo charge by rows this will have a negative impact on the number of rows we consume waste to be specific. why cannot the original datasource be used .
-
Formula in Magic ETL
Hello, As a newbie in Domo BI, I would highly value your assistance in resolving an issue that I have been unable to solve. I want to write a formula in Magic ETL that does the same function as the one in Excel from the picture: Compate D2 and D3 and if they are the same AND M3 is blank, take the value from N2. If not,…
-
Creating a separate column using magic ETL
Hi there - I am trying to part of a value that is in a column and change it to be the full name. I keep getting syntax errors whehn going through ETL formula tiles. My formula is alot larger than this but this is an example - I have tried = instead of Llike, as well as contains, nothing seems to be working (becuase the…
-
Filling Blank rows with previous non-null value from the same column
Raw Data : Product Values A 23 24 25 B 45 56 76 C 34 D 55 Expected Output : Product Values A A 23 A 24 A 25 B B 45 B 56 B 76 C C 34 D D 55 Here i am trying to fill blank rows with the previous non-null value in same column and i want to accomplish above scenario in MagicETL, any help will be highly appreciated. Thanks in…
-
SQL in ETL
Hi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we are doing in a table is taking out extra characters from a column to create a new trade_id Here is how we are doing it. when I go to add the formula tile and copy and paste this syntax, ETL is saying it doesnt recognize the…
-
Filtering Records Based on Aggregate Criteria
I've been trying to do the following but can't figure out the best way to do it. I have a table that looks basically like this: user_id|ticket_id|inquiry_type I want to filter out rows for a specific user_id when ALL of the rows for that user_id have a value of "false_inquiry" in the inquiry_type field. But if the user has…
-
Can you turn a date range into each individual date in the range?
I have a start date and end date with a total sum of hours to work. These are each 10 days with an average of 3.2 hours and 2.8 hours respectivelivy. Is there a way i can display each indiviudual day of the date range with the work per day? Something like this?
-
I wanted to rename few items in a column based on this campaign, in the ETL
Hi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this in the ETL. Here is my formula CASE when campaign = 'CM1' then 'Web' else channel END But this is not giving me the expected output. Could anyone please help me with this? I actually wanted to achieve this in ETL only, not in…
-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"
Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate a pacing percentage. (`Delivered Impressions` / (`Campaign Flight` - `Days Remaining`)) / (`Total Goal` / `Campaign Flight`) We've been using this dataflow and formula without any issue for months and now we're getting this…
-
Calculation Error : Domo is having trouble validating this formula
Hello everyone, We have three SQL formulas that have worked for the better part of a year but twice now will unexpectedly develop a calculation error without any more detail. This stop the flow in our ETL structure. We are trying to transform data in a couple of ways. Below are the three forumlas that are failing in the…
-
append rows in magic etl not working
Hello All, I am attempting to append two data sources through magic ETL. They have the same columns and data type. table 1: A,B,C,D,E,F,G Table 2: A,B,C,D,E When i try to append the two tables by including shared columns, the resulting table looks like this Table 3: A,B,C The table includes the combined A,B,C columns from…
-
REGEX Extracting Names
Hello, Regex question here.. I am attempting to extract names from a string similiar to this but haven't had any luck: Submitter: ["Joe Smith ","Jill Smith"] I would like to retain the commas between names so that I can split these values to different columns afterwards, like this: Desired Result: Joe Smith, Jill Smith Any…
-
Creating a Pass/Fail Test in Magic ETL
I am trying to create a pass/fail test in magic ETL. There are four test it needs to go through to pass or fail. Once a row is listed as fail I would want all the rows matching that submission ID to fail as well how would I go about this or what is the correct formula to use? for example It failed the first test but passed…
-
Cant edit the ETL, beside I'm the owner
Im having some issues with my dataflow,i cant edit the ETL beside im the owner, i dont now what i have to do to solve the issue
-
How to remove duplicates without affecting the blank cells?
Hii Team, I have a dataset which is a join of a user name and phone number and their transactions ID however I need to remove duplicate transaction ID without removing the blank cells as if the user has no transaction ID against it. That means that user has not conducted any transactions. Eg: Dataset Sr No Name Transaction…
-
Converting Text column with fiscal periods to a date
Hello, I have a relatively simple dataset with one column that lists fiscal periods, another with some product types, and another with sums of those product types. I'd like to use this data to create a bar variance card, but Domo is currently looking at my fiscal periods column like they're 'text' instead of 'dates.' The…
-
Question about using recursive reports but only reclusive until post month
I am working on setting up some recursive data structures to capture the data I need for this instance it charges in a period. We can call this resident's charges. Charges are accumulated until a post date which is most of the time the 21's day of the month with some exceptions. I have a small web form that lists these…
-
Dataflow loads in preview, but not in actual dataset?
Any troubleshooting tips for us? Our data flow's outputs: Work when we run a preview When we run it, the datasets give us an "Unable to load this DataSet" error. (The second dataset is my "test" output where I kept moving it around the flow, trying to identify if a specific part of the dataflow was breaking the final…
-
json data
We have a no SQL database, where our data is stored in Json format. Which is nested and has further nesting based on one to many relationships. We need to have a particular tabular form or method to map this dynamically changing data into domo
-
List of Months between two dates
Hi All, I am trying to create a Magic ETL V2.0 that lists the name of the months in between a hire and termination date for employees. I want to create a bar chart of number of employees who are active and terminated within a given months time. i.e. Hired: 5/1/2022 and Terminated: 8/31/2022. Months active = May 2022, June…
-
Removing Duplicates with Condition
Hi All. My dataset have a lot of duplicate rows so I wanted to use "Remove Duplicates" in ETL based on the Shipment ID. However, there are some products that are hazardous. I want to have the hazardous row left remaining when I remove the duplicates if there is a mix of Haz and non-Haz. Any function or use of "Rank &…
-
Division By Zero - Be Aware - Failed IFERROR, IFNULL, and GROUPBY
When you're performing calculations over 100s of millions or records sometimes you come across division by zeros in which you're hoping the software you're using would manage accordingly, I ran into a scenario in an ETL scenario where it lead to having more than a 10% revenue shortfall in my numbers. Generally in Domo if…
-
Lead Function in Rank and Window Returning Self Referencing Value
For some reason I am getting a self referencing value rather than a NULL. In this example, I was expecting the Next Row Column to be NULL for the last row. Instead, it seems to be self referencing the student enrollment # column. The first 5 rows in the example are correct. Is this the default behavior of this…
-
Automatic Record Matching - Customers
Howdy! New Domo customer here - first time posting in the Dojo! We're bringing in accounts from various systems. Sometimes an account from system A is the same account in system B. I'm wondering if there's a way to do some sort of smart match to automatically establish relationships between records. Something like, if the…
-
How to force legend to stay in a Specific order
I have two questions: 1. Is there a way to sort the legend in a specific order and have it stay that way? I would like it to be as follows: A B C D F But I am having trouble finding the option in chart properties. 2. There is also an extra option in the key that is showing up that doesn't apply to anything. Is there a way…
-
New nested statement
I Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error. I tried doing it a few ways and both are creating errors SELECT CASE WHEN "Status__c" in ('Booked') AND > 111 THEN 'TIER 4' ELSE 'TIER 1' END FROM "sfdc_travel_raw" or this query SELECT *, SUM(case WHEN "Status__c" = 'Booked' >…
-
Any Way to Use Regular Expressions to Change Case of Specific Words
I've got a requirement to change the appearance of articles and prepositions in words in a column to be displayed as lowercase after running a Title Case on the rest of the phrase. Right now, I have an extensive list of text replacements in Magic ETL to do this, but I was wondering if there might be a way to do this with a…
-
Dataset column description mass load
Is there a way to be able to edit the column description field massively. For example if I have all the descriptions that need to be input but there are datasets that have over 800 columns .... is there a way I can upload these to the dataset?
-
Is there a equivalent Excel WORKDAY function in DOMO? Or is there any workaround way?
I have a start date, I want to know the next work day after a specified number of days. (exclusive of weekend and public holidays). In Excel, WORKDAY function can do this. Would like to know how to achieve this in DOMO. Thanks for any input.
-
Summing Values Between Dates & Comparing to Other Values
Hello, I'm looking for help with a problem I'm having comparing pay for a pay period to a providers billings. I have removed rows for simplicity in the screenshot below, but I'd like to sum the `Billed Amount` between the `Period Beginning Date` and `Period End Date`. Then I'd like to show that info on a bar graph with the…