sql
Discussion List
-
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…
-
Beast mode to kill div0 errorsHi, can anyone tell me why If my "A" code works, and my "B" CASE WHEN... THEN …
-
How do I used a Create / Use / output table using a SQL transform SQL type / CREATE PROCEDURE?I'm trying to just work out the basic syntax / method in DOMO SQL transform of: Create Stored Proce…
-
Summing up filtred values based on criteriaHey guys, I will try to explain my issue, I'm really loosing hair on this one, hope wil get feedba…
-
SQL - join where a column is between a number rangeHello, I cannot for the life of me figure out why this "where" clause is giving me troubl…
-
Join based on filter criteriaTable A (Completed Evaluations w/ dates & locations) Table B (Locations Universe, all available…
-
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 thi…