-
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…
-
% of Total Sales Column Add
Hello All, New to Domo and appreciate the community support. I have a table card that includes net sales by cashier listed for the day in descending order. I would like to add a column that shows their sales as a % of total sales for the day. How would I do this ? Thanks !
-
Is there any way to do an UPSERT with data coming from Postgres?
Our main SQL database is Postgres, and we're populating DataSets with calls similar to select * from view_for_domo We're using full replacement, rather than incremental pulls. We're interested in using incremental updates rather than full refreshes of the DataSet to speed things up. After checking the options I can find in…
-
Converting Decimels Numbers into Hours, Minutes, Seconds
I currently have a column that has decimel numberic values and I need to convert these values into a time format. Please note that the column containing this data is not a Date/Time column. A beastmode or and ETL transformation will work for me. Example: Column contains 2.25, I would like for it to display as 2:15 or…
-
conditionally start a dataflow
I am aware of the 3 ways to start a dataflow...manually, on a schedule, and only when datasets are updated. I have a use case (which I suspect others may as well) where I only want a dataflow to run conditionally. Example: We are pulling multiple datasets in from an application that on occasion experiences data quality…
-
SUM with multiple conditions
Hello everyone, I am having trouble with a DOMO Beast mode sum Calculation. Below you will find my existing calculation. I am looking to add the value of all records that have a date to Customer in column A and exclude those records in column B that have a payment date. Essentially I am looking to calculate the value of…