-
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…
-
Automating Multiple Imports
I am very new at using workbench so sorry if this question is too stupid to even consider. Essentially I want to pull a report for a partition of data. For example select * from tables where GroupType = somenumber Instead of creating a new job for every iteration of somenumber I was wondering if I can have Workbench…
-
Pulling numbers as DECIMAL over SQL
I'm migrating cards to some new DataSets and am checking for conflicts in advance. We've been pushing Excel spreadsheets and will now be pulling from Postgres. Domo has three numeric types: LONG, DOUBLE, and DECIMAL. I cannot figure out how to pull data into DECIMAL. I care only because they come in as DOUBLE and Domo sees…
-
MySQL newbie question
I have a dataflow I've built in Magic ETL, and I want to add a new column using a conditional statement to return the value from one of 3 existing columns (doing this in Beast Mode prevents me from getting the correct aggregations, so I'm trying to add in the dataflow itself). So I want to have Invoice Sales returned if…
-
Domo Connector IP address
Hi, Can anyone please provide the IP addresses of the Domo Connector, so that we can add the rule in our firewall to access MS SQL database.
-
Line Breaks Stripped from mySQL Text Fields
Using the mySQL SSH connector, my text fields (VARCHAR and TEXT) are getting line breaks stripped, making all my text appear as a single line, even though the source data has line breaks. I've tried using a BLOB field, as well, but those don't seem to work at all. Is anyone else experiencing this? Is there any way…
-
Changing a string to a number
Hi all, I have a column that has values like this '14%'. Domo is considering it a string, but I'd like it to number, preferably a decimal. I've been trying a few different SQL functions in Dataflows to chop off the percent sign (and then CAST it into a decimal), but the ones that would do the trick don't seem to be…
-
Pivoting data in data flows (Year over year || week over week)
Hi, I have account information on one of my data sets like this: Registrations: Name Date_of_Registration Daniel 2015-12-01 John 2015-10-22 Peter 2014-12-01 I want to use dataflows in order to pivot this data in two ways: #1 New registrations per year 2014 2015 1 2 #2 New registrations per week Week 2014 2015 10 0 1 12 1 1…
-
Need to see a value by week with current year next to previous year in a Table Card
Hi, I am trying to rebuild Tableau Dashboards in DOMO and I am running into a lot of trouble dealing with dates. Some of the issues I have been able to figure out, but this one has me stumped and none of the available related advice seems to work for me in the SQL Transform component: Using 3 fields: 'date', 'line', and…
-
CROSS Apply equivalent in Redshift SQL
Hi All, I am trying to find the equivalent of CROSS APPLY in the query below. Can you please help.. WITH CTE AS ( SELECT *,ROW_NUMBER()OVER(PARTITION BY "ORDER","ORD_DATE" ORDER BY "DATE_VALUE" DESC)AS RNum FROM input ),CTE2 AS ( SELECT "ORDER","ORDDATE","PRMDATE","DATE_VALUE" AS recdate, DATE_SUB("DATE_VALUE", INTERVAL 7…