-
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…
-
How to get aggregated data without losing rows
I am looking to get count for each row without loosing any row. It can be achieved easily in excel using count if in excel but here how I can implement in ETL or Beast mode? Please see the sample input and output I am looking for in below image
-
variance
Performing the percentage variance calculation gives me this warning An issue has occurred during processing. We are unable to complete the request at this time. What can I do to solve it or what is it due to? Thank you
-
Adding Column to Calculate Difference Between Weeks
Hello, I am trying to add an extra column that will calculate the difference in order volumes from week to week. See attached screenshot for details: Week 1 -> Week 2 difference is 7394 Week 2 -> Week 3 difference is 53 Week 3 -> Week 4 difference is 452 Basically using the current week's number and calculating the…
-
Is there an alternative of distinct on for redshift?
Hey, I am trying to build a dataflow using redshift but distinct on is not supported. It's a simple query: (SELECT distinct on ("id") var_list.* from "indicator" as ind order by "id", "rank" desc) Any suggestions for workarounds?