-
Recalculate the transformation of the dataflow based on the specific time range selected in the card
Hi everyone! I am trying to create a card to show the number of active customers. Active customers are those whose the sum of revenue and the sum of quantity are more than 0. Practically, it means to exclude those customers whose the sum of revenue and the sum of quantity are less than or equal than zero. The reason behind…
-
Merging new and legacy datasets
Hello, Experts! I am reaching out in hopes that I get some guidance on the best approach for building out an ETL. Our company is undergoing a point of sale transition and things are going well. We currently have legacy data in one dataset and new data flowing into Domo separately. My CEO is wanting to see week by week…
-
Remove text without removing decimals
Using an ETL, is it possible to remove text without removing decimals? For example, I have a dataset that includes values like this: 1.0 8.54578 N/A 7.49687587125516 ..... Using "Text Formatting" to "Only show numbers" results in the following output: 10 854578 749687587125516 How can I extract the numbers from a column…
-
Week over Week Metrics - Multiple Stores to Show
Hello, Experts, I have a use case where I am looking to build a card for week over week showing in table format a list of stores in one column and total sales in another column for the given X # of weeks. Based on my reading, it looks like I will have to build a new transform to be able to accomplish this. Can you confirm…
-
Amazon DynamoDB Data ETL
My team recently began to transition one of our key source data systems to be housed on AWS DynamoDB. Our connection to the legacy system is cumbersome to say the least (e.g. use a custom powershell script, workbench, and csv to feed data to Domo)...So, I was excited to utilize one of Domo's API Connectors to DynamoDB,…
-
Add values from Web Form row as Columns to a Dataset
Hi, I want to use a web form dataset to allow a user to enter values for 4 variables. Basically, a single row with 4 columns for the variable values. I want to then add these values as additional columns to each row in another dataset. What is the easiest way to do this? The use case is, I want to be able to use the…
-
Break Line based on character for use in Mail Merge
Greetings All, I am seeking advice on how to add a break line to a string based on a specific character. I was able to get the table to look semi correct using ETL + Beast Mode. REPLACE(`String`,';','<br>') But I am unable to use my mail merge doc because the data doesn't doesn't export to excel correctly. I am a bit…
-
Quickbooks Enterprise - ETL Transaction Pickup Issue
The nuts and bolt of the issue is our Quickbooks ETL logic is not picking up edits made by end users. We are wanting to pick up the latest transaction. We validate or process on the date and transaction number field. So say there is transaction number (TN) 123 on 1/29 and TN 124 on 1/30. If the user edits then edits 123 it…
-
Case Statement in Magic ETL
Hello, Is there a way to implement a Case Statement (not nested Case Statements) in Magic ETL? Thank you, Nick
-
ETL joining causes an output dataflow that is too big?
I am very new in using Domo, so hopefully I can explain my situation well. I have three datasets that have different column names and structures, even though each dataset has same columns too, like 'Employee Name' and 'Employee ID'. I tried to join them (using inner join) and run preview with 10k limit, but it showed the…
-
Filter out junk data
There is a dataset I import using Workbench, then transform using Magic ETL. The data includes values between 1-10, but sometimes will contain a random junk value like 324568. I'd like to filter out all values that don't fall between 1-10, but can't find a way to do this wihtout specifying every possible junk value, ie.…
-
Updating data in a dataset based on date
Hi Everyone. Long time lurker first time poster (please be gentle) I have a dataset that contains a lot of customer data (not to brag or anything) and I'm trying to update the customerID column for one specific customer from 123 to 456 only when another column "event date and time" is before 8/1/18. Essentially, I want all…
-
Add group by as an additional field
Hi everyone, I am looking to add a column to a dataset where I join all my users and their orders (could be 1 or more) and get a count of how many orders an individual user has placed. I pulled all the columns I want in my ETL dataflow, and then calculated this field using the "Group By" transformation. I group by…
-
Magic ETL appears to run all the way to indexing, but fails with an un-specified “Server Error"
My ETL appears to run all the way to indexing, but keeps failing with an un-specified “Failed while executing....The server experienced an error". When I view the details of the "Run", each of the steps has "no additional details" It is an extraordinarily simple: two inputs, group one, join both, output. I have used both…
-
How do I share ETL with a Privileged User?
I am trying to share a few Magic ETLs and MySQL DataFlows with a privilaged user. He sees some of them but not all that I intended. I suspect that the etls visible to him corrispond with the cards I have granted this user permission to see, but can not be sure. Some of these etls inform other processes and thus have no…
-
How to merge two rows in one?
Hello Everyone, I have 2 datasets using the email connector. These 2 datasets contain information from 2 different platforms (Adform and Adwords), by means of a DataFlow I made a data unification of these two so that they remain in a single data base that I call "Merge Dataset". Now up here, I create some cards with the…
-
How can I take multiple columns and create new rows based on the data?
We input some data through a form that is very limited in how it organizes the data. It currently looks similar to this (these are the column headers): Date / Manager / State / District / Site / Type of Inspection / 1 - Category of Violation / 1 - Violation / 1 - Plan of Correction / 2 - (same 3 column titles) / 3 - (same)…
-
Group By value with Average aggregation calculating differently
Hi there, I believe I'm missing what is going on with my various attempts to Group By source data in order to gain an Average aggregate of a score. I take the entire dataset and when I place it in a table card and AVG the score, the calculation is correct but anytime I use the Magic ETL I was presented with a different…
-
Pivoting multiple columns to one, while keeping correlating data
Ok pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across an unknown number of columns, and bring it all into one uniform column. The problem I have is keeping the associated row data when you move the data into one column. See below ---> What I have: What I need: How do I do this?
-
Map empty/null Date and Time using ValueMapper
Hi, I would like to map empty values of Date and Time to another value (for example, current date and time) using ValueMapper. Is there a way to do so? Thanks.
-
ETLで日時に9時間足す方法 UTC→JST変換
UTC日時をJSTに直すため9時間追加したいですができず、そのために ETLの後に DataFlow SQL を入れています。 ETCで時間の計算や、タイムゾーン変換はできますか？
-
Magic ETL Trim left of decimal
I noticed there isn't a ton (easily found) info on the different Regex to use to trim off data. My use case was I had a file using a numbering system before a product. So instead of saying Lowe's, Home Depot, Walmart it would sayd 1.Lowes, 2. Home Depot, and 3. Walmart. I found some regex that drops the period and what's…
-
Magic ETL Issues on Internet Explorer 11
Please weigh in if you use Internet Explorer 11. I thought this was a common issue, but I learned it may not be. Magic ETL does not work properly in my IE11 browser. Please let me know if you have IE11 and either have or do not have this issue. Thanks!