SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Discussion List
-
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…
-
Calculate rank so that the smaller number is higher rankI need to calculate the rank on a metric where the lower value is higher in rank, and the higher va…
-
has anyone had any luck creating dynamic columns in mysqlwhat I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to …
-
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 …
-
MYSQL - Trouble adding new column via LEFT JOINHello! I am having trouble adding a new column, "Dummy", to my output dataset. Although t…
-
Schema not keeping changes, but no error given - have you run into this?Hello, So I have set up a job using MySQL ODBC - executed, all good. Job T Then set up another job …
-
'Incorrect column name' doing a Dynamic PivotHi there! I've been following this tutorial for dynamic pivot and so far it has worked: https://do…
-
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…
-
MySQL Recursion Performance/Speed IssuesHello! I am looking for suggestions on how to improve the performance of my mysql dataflow. Current…
-
Appending an update set to itselfHi, I have a MySQL dataflow that is built from API reports from a vendors application. The idea is…
-
access max.date from sql tableHi. I have two input datasets in SQL Magic Transformation. One table called daily the other one est…
-
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…
-
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…
-
Is it possible to use while/do loops in MySQL in Domo Dataflows?I have data that has varying rows of data for each identifier, from one row to 26. For each identif…
-
Dividing in SQLI currently have this code: categorizing some leads. Select `Year-Month` ,`Lead Source` …
-
Is 'Partition by' supported in DOMO SQL?I tried to create a new table in DOMO SQL using the following syntax in sql : SELECT `G_L Account N…
-
Is it possible to do CTE hierarchical recursive query in MySQL?I have a table with thousands of rows in which there is a relationship of child/parent between the …
-
MySQL Data Flows clarification: MySQL version & window functions (row_number)I've neglected MySQL Data Flows because I'd passingly assumed that they were for MySQL-derived Data…
-
DOMO SQL MAX(date) not workinghello, hope someone could help on my SQL: I just created a simple SQL under DOMO MySQL to select s…
-
How can I create a new column with extracted numbers in SQL or ETLI have a column called 'description' which can contain multiple elements. One of them is 'Order #1…
-
ETL SQL StatementHi, I'm not familiar with SQL and wondering if someone can help with a SQL statement in an ETL …
-
Help identifying and isolating a date held within a string of textHi all, I'm hoping some creative minds out there can help with a business problem I am having.…
-
SQL Syntax tips for a beginnerHello, I am new to Domo but want to learn how to use Domo with SQL. I am advanced in R and I un…
-
Unknown SQL type - 110I am getting this error on a workbench job, "Unknown SQL type - 110" Does anyone know how…
-
SQL Queries for SQL Server DatasourceHi Team, We are planning to migrate from Cognos to Domo. 1. Issue is we have prebuilt Custom SQL …
-
Mimic VLOOKUP based on Date RangesI'm looking for a way to merge two sets of data based on approximate matches. I have two datasets: …
-
Multiple SQL Update Statements in Same TransformI'm currently adding one Update Statement per one Transform process box/dataflow in the Domo MySQL …
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 418
- Cards 411
- Magic ETL 386
- Beast Mode 366
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 165
- Data Flows 162
- Workbench 148
- SQL 131
- Charting 131
- Date 126
- Analyzer 121
- Table 120
- Governance 103
- Visualization 100
- Domo Everywhere 98
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55