sql
Discussion List
-
Magic ETL HelpHi, I am going through the Data specialist practical test and am running into troubles. Here are my… -
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.I have a large table showing plant department and their part numbers with the quantity scraped / do… -
Is there a way to aggregate the output using a FIXED function used in a CASE statement?I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate … -
3Linter and Auto Format in SQL dataflows and Beast Modesfor better visibility (and to support handover between users, it would be ideal if all the places u… -
Aggregate count function does not work in the denominatorWhen I use the following statement in a card summary, it works properly. But when use it as a value… -
Is there a better way to perform a variable-length recursive query using MySQL ver. 5.6?I'm looking to perform a recursive query on a data hierarchy with an unknown amount of levels. I've… -
Add Data that has been modified in the last 7 daysI have a snowflake dataset that has a modified date column. I want to merge the data that has been … -
CROSS Apply equivalent in Redshift SQLHi All, I am trying to find the equivalent of CROSS APPLY in the query below. Can you please help..… -
Can someone give me DDX Bricks examples which use traditional SQL (using JOIN) to query?I want to use traditional SQL to query to fetch data from database in ddx bricks. My sql query cont… -
Need help reviewing sql query used to create domo sql dataflowHello, I am working on moving one of our SQL Queries to Domo. This query looks for users who have … -
Deduplicating a table based on the content of certain columnsI have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of… -
Creating a join from a lookup tableI have created a dataflow that joins two sets of data together, however when i join them together i…
-
LISTAGG or equivalent during data import from NetSuiteWhat SQL should I be using during an import to collapse data from a column into ',' delimited strin… -
How to use Escape characters in Beast Modes?Hi, I am trying to create a web link for a card using a beast mode and some of the values that will… -
Is AS valid in Beast mode?Good afternoon, Can AS be used in Beast Modes to create aliases? It doesn't seem like it but I migh… -
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E… -
Can I write SQL directly to my data sources?I know I can click on "SQL" in the top ribbon to write SQL against my data sources using … -
Rolling 30 Day Formula in magic ETLHi, I am trying to write the formula above within magic ETL. Column A consists of static values. C…
-
Do MySQL dataflows support the use of the WITH clause?I'm trying to use a WITH clause as outlined here: https://dev.mysql.com/doc/refman/8.0/en/with.htm… -
How to Create Monthly Averages for Headcount?Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Averag… -
use fields from different tables group by date to calculate percentageHi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic T… -
Need help to connect a Microsoft SQL server to DOMOHow can I connect MS SQL server with Windows authentication mode only? Should I ask the server owne… -
Problem with SQL for WordCloud ChartHi all! So, I am trying to run SQL code using these instructions https://domohelp.domo.com/hc/en-us… -
Remotely trigger a DataSet refresh?I'm checking out some of our options for speeding up data ingestion in Domo. A few of our Postgres … -
access max.date from sql tableHi. I have two input datasets in SQL Magic Transformation. One table called daily the other one est…
-
Workbench ODBC - Dynamic query/parameterWhen we are establishing a new job in Domo Workbench of the type ODBC, we write the query in the bo…
