-
MagicETL2 Filter issue?
I have a filter in my dataflow: id NOT EQUAL value This filter removes all rows that have 'value', but it also seems to remove rows that have null in the 'id' field. Has anyone seen similar behavior in the Filter Rows ETL?
-
Duplicates : counting them, not removing them?
Whats the best way to count duplicates in a table using ETL and or Beast mode on a card? Lets say I have a table of data that shows me how many times each class uses a specific tool so I end up with a table with a list of classes who have used the tool. And, each class can have multiple entries showing each time they…
-
Show Top 10 in Chart (Rank in Beast Mode)
Hi, I am trying to build a multiline chart based on the following Dimension: Date (x-axis), Search query (line series) Metrics: impressions and position The multiline chart should show the position (y-axis) by date for only the top 10 search queries based on the total impressions during a the selected time period. I cannot…
-
What is wrong with my Pivot - Uncollapse Columns? Showing Null
Hey I'm trying to pivot a column, but the new columns are all null Here is the original data This is how I've set up the pivot info This is the output I get: Originally not every Customer_ID had ever Level(1/2/3) I thought this was the cause of the nulls but I've fixed it so every Customer_ID has all levels and still the…
-
Show all dates between start and end date columns on calendar card
I have three columns; 'user name', 'start date' and 'end date' representing time off from work. I'm wanting to use a calendar card and show the days where someone will be off work. Currently, I can only use one date column which I've chosen 'start date', however, it only represents the first day someone is off work. Is…
-
Joining or Appending Data Help
I have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with details including year and country of operations. I have created cards to show the total number of jobs per year. I have another dataset (dataset 2) which shows historical revenue by Year and Country but it is not specific to…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
-
How can we use similar function as Vlookup??
I would like to offer a volume discount price for each company A, B, C and calculate total biil. There are 2 datasets like the below. When we sell 250 of Products to Company A in 2021 Feb (Dataset B), I would like to apply Price 4 USD on the price list for Company A (Dataset A). Then the total bill will be 1000 USD. If…
-
Page Analyzer Link filter not working - Deep Linking
Following the notes on Sample Beast Mode Calculations: Miscellaneous Transforms, the section on Creating Page Analyzer Links (or Deep Linking with Filters). I am having trouble getting this to work - my first thought is there is some minor syntax issue I am blind to right now. Hoping another set of eyes can help. The Field…
-
ETL
I have a column with multiple categories values, I want to convert this categories values to column labels. How do I do this. In the screenshot attached below I want to convert values of column '123 1' to column labels.
-
Recursive Issue Help - New Magic ETL 2.0
Hello Community. I am trying to follow the recursive guide here, but I am obviously missing a step or two as my data is not showing the historical at all. In fact whenever I add new data, the new data is the only thing that seems to be available. Can someone kindly help and put me on the right path please? As you can see…
-
Business days between date function
I use the datediff for business days function in a number of mysql data flows and it works great. However, I'm getting some very strange results on the latest flow that I'm working on and I can't figure out what's going wrong. I have a start date which I'm looking to compare to the current date. However, the code I'm using…
-
What is the point of a full join in Magic ETL?
So I get Left, right, and inner joins. But, what is the point of a full join if it returns null values for any columns that don't have a match? How is that different from an inner join? Also, how can I make sure that the non-matched items are included in the resulting dataflow?
-
"Failed to start data processing engine"
Hi, I get this error message across various datasets a few times a day. It only occurs from scheduled/dataset updates. It's not a major problem as the dataflow succeeds on the automatic retry, but the notifications can be annoying. Has anyone else had this issue? Is there a fix for it (or can I at least remove the…
-
How do i trim out an email address from a field with a string?
How do i trim out an email address from a field with a string? Example of Field: Yes, we accept this current pricing and would like to proceed with this order. Thank you, Bob Dole Lab Research Analyst Poss Lab—Dole University bob.dole@some.edu Thanks
-
Error with size field on SQL
Dear friends, I am uning the Jira conector to get details about Issues openend. A few days ago was necessary to execute a migration on Jira and with this action the custom fields received the sufix (migrated). After this process a facing to use the Dataset on SQL process. The system has return the folowing error message:…
-
Pivot Help
Hi, I have a situation where a column my have different rows of the same values, but the values are in different orders and therefore they are different buckets in cards, when they're actually the "same" thing. And example of this is in A1:B3 of my attached image, where both rows under the BH_TAT.Antigens column have the…
-
% Change Question
Hey all, I have a questions. I would like to be able to show day over day, week over week (different table cards) and highlight a 10% increase and 10% decrease in values. Is there a way to do that. Ideally I would like to just highlight with a color that field that holds the value. attached is an example of what I want to…
-
Set goals in ETL
Hi, I'd like to take a dataset (for instance sessions per day in Google Analytics or followers on LinkedIn per day) and and daily targets to it. So lets say these are the dates and number of sessions for March until now: 1: 25 2: 35 3:25: 4: 30 5: 56 6: 66 7: 10 Then I'd like to put in the goals for each day that I have in…
-
How to view data table schema
How can I create the data table schema and table relationships
-
Filter data based on if it matches the data in the other data set.
I have two data sets. I need to filter based on if the same data is in the other sheet. If so I only want that filtered data to be in the sheet. An example is if I have a row about apples. If a row says Red. I only domo to check to see if that row exists in the other sheet and if it does give it to me in a output data…
-
Separate Date from the text
Hi, I want to separate the Date from the text and put it in a new filed called "launch Date" For eg: Suppose the text is "Email 2021-03-01 best practices in Email Marketing" I want to separate out the "2021-03-01" text and put it in new filed called "launch Date". then I will update that filed datatype as a "Date" Please…
-
Doubt in sharing the dataset to the users with PDP
Hi, I have a dataset which has to be shared to the users without "Can share" Option. If I give "Can share" option the users will be able to share the same dataset to other users without the notice of Owner of the dataset. How can I give the access using PDP option All Rows So that they can only view and download the…
-
MYSQL ETL including parameters
Is there a way to create parameters in SQL statements within the MySQL ETL data flow? Here is an example: set @lastDate = select * from `last_date_of_spent_data`; -- this returns a single column and row Select `Program Name`, @lastDate as LastClosedPeriod
-
Combining Data Points after Split Column
Hello! I'm attempting to get a new column that shows flight dates/run dates. The original data is located in a Line Item column (screen 1) and after a Split Column action (screen 2), the flight dates/run dates end up split over several different columns because the # of _delimiters in the original column isn't the same.…
-
Python
Hey guys, I can't find any documentation on how to use the python widget. I've read the documentation on the site already. It didn't provide me any insight on actually implementing it and the Schema tab is far too confusing. I don't even know why I would import all my selected columns if I'm going to be creating another…
-
Magic ETL dataflow not running because of no change in data
Hello, So, I created a magic ETL dataflow that selects a row from a calendar where the shortdate=Current Date and I scheduled this dataflow to run at 6am daily. The dataflow has not run once becuase it states the following: Your DataFlow was last triggered on 4/3/2019 6:00 AM but there was no change in the data, so it…
-
Date Add Formula
I have no clue what I am doing wrong, please help! I am following the function description and it seems like I have the correct arguments but maybe I am overlooking something. I am just trying to add 1 month to the current month using a Formula tile in ETL 2.0.
-
using google cloud store postgres
I am told I need to put the IP address of DOMO onto the networking "connections" in my google cloud platform to allow DOMO to pull the data from my SQL database. Would anyone know what that approved IP address is for DOMO ?
-
Is it possible to switch a data set to a different dataflow?
I've got a team who uses the Excel plugin extensively, through which they query a particular dataset. However, this dataset is based on an ETL flow which I'd like to recreate in SQL so that we can iterate on it more quickly. Since they'd have to remake all of their query tables to be based on this new data set, I'm…