sql
Discussion List
-
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…
-
Dividing in SQLI currently have this code: categorizing some leads. Select `Year-Month` ,`Lead Source` …
-
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 …
-
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…
-
17ETLからSQLコードの出力初めて投稿させていただきます。 DOMOのETLやBLENDで作ったデータフローから、SQLコードを出力するような…
-
Dataset query fails when not using a where clauseI'm trying to get all the data from my dataset by executing a simple query: Here's what my code loo…
-
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.…
-
9クエリをオートフォーマットしてほしいBeastModeやデータフロー(SQL)にて、 構文をオートフォーマットしてくれる機能がほしいです。 クエリ…
-
4MySQLのコード入力時に、文字列以外の全角文字が入っていたらハイライトしてほしいMySQLのコード入力時に、文字列以外の全角文字が入っていたらハイライトされるようになっていると、 実行…
-
16CLI or native SQL-like GUI for SQL toolingI would like to see the possibility of creating a SQL-like CLI or GUI (thinking psql, vsql, or Sequ…
-
How to create a backlog trend card?I'm trying to create a card that shows the trend of case completion against a backlog each month (b…
-
5データフロー(SQL)の変換をカテゴリごとにまとめたいデータフロー(SQL)で変換を追加していく場合、 複雑な変換をするほど変換の個数が増えていってしまいま…
-
MySqlにて累積平均を求めるには?①のようなローデータがあった場合に、日付ごとに累積で平均値を求め②のような出力を行うには、どのような…
-
Add group by as an additional fieldHi everyone, I am looking to add a column to a dataset where I join all my users and their orders …
-
Automating Multiple ImportsI am very new at using workbench so sorry if this question is too stupid to even consider. Essenti…
-
Pulling numbers as DECIMAL over SQLI'm migrating cards to some new DataSets and am checking for conflicts in advance. We've been pushi…Answered ✓ Closed DataSquirrel 355 views 11 comments 1 point Most recent by DataSquirrel Card Building
-
4SQLの一部分のみ選択実行したいデータフロー(SQL)にて、複雑な構文を書く場合が多いです。 現状デバッグ時には、下記方法でデバッグして…
-
5データフロー(SQL)でプレビュー結果の表示/非表示を切り替えたい。一度SQLを実行すると、結果のプレビュー画面が表示され続けてしまいます。 (適用を押してポップアップを…
-
Domo Connector IP addressHi, Can anyone please provide the IP addresses of the Domo Connector, so that we can add the rule …
-
DataFlow SQLのjoinが遅い問題DataFlow SQL で left outer join などでテーブルを結合すると、処理が非常に遅くなります。結合するテー…
-
1Magic ETL Errors and Sample DataWouldn't it be great if there was an error on a Dataflow (Magic ETL or MySQL) that the sample datas…
-
1Generate SQL Inside CardsIt would be quite a helpful feature to have a button to press which generates the SQL which the car…
-
Changing a string to a numberHi all, I have a column that has values like this '14%'. Domo is considering it a string, but …