-
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!
-
Funnel Card using Column Aggregates?
Hi, as the title sugests, I am having trouble creating a beast mode that I can use to funnel the totals of several different columns.What I would like to do is create a funnel for marketing emails, columns are 'email delivered', 'email opened', 'email clicked', and 'email bounced'. Each row in the dataset is an email…