Domo Sql not populating all columns in the results view, How does one solve this?
Answers
-
'Domo SQL' is not a thing.
Your query is running in a MySQL 5.6 database.
just type SELECT VERSION()
Your preview is doing exactly what your Query says... SELECT 3 columns. What are you expecting?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@jaeW_at_Onyx I'm expecting 3 columns but as you can see, only 2 are being populated and the order by also is not being applied as expected.
the MySQL version is 5.6.37-82.2-82.2, my issue is with the output not the version of MySQL
0 -
@jaeW_at_Onyx I'm expecting 3 columns but as you can see, only 2 are being populated and the order by also is not being applied as expected.
the MySQL version is 5.6.37-82.2-82.2, my issue is with the output not the version of MySQL
0 -
does your WHERE clause say debtor is null?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@jaeW_at_Onyx yes
0 -
:P
That's why you're not getting results. // try filtering on IS Not NULL just to confirm.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@jaeW_at_Onyx this is the same query giving me the desirable output on a DB client.
0 -
When you run the dataflow do you get the desired results?
Also, fundamentally your result / query doesn't make sense that you posted.
in your JOIN clause you're saying a.debtor = b.debtor. If that's the case a.debtor can never be populated IF b.debtor is null.
also if you expected b.debtor to be null (WHERE clause) then it doesn't make sense to ORDER BY b.debtor = null because it is NULL.
What are you trying to accomplish?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@jaeW_at_Onyx , as you can see clearly the order by, is on a.debitor_id on the image above FYI this is an alternative way of writing a query that would need windows function to achieve the same results and since DOMO uses a MySQL that doesn't support windows function thus the query, also please understand the query before you respond.
0 -
Do you have NULL debtor ids in your transaction table? What happens if you filter also for a.debitor_id is not null?
You query appears correct and should get you the first transaction for a debitor (Yay for lack of window functions in MySQL 5.6).
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith the query works perfectly as an alternative for window function, my issue is when I write the same in DOMO, it doesn't populate the debitor_id column, and also the result is not ordered by the debtor_id.
0 -
Right, that's what I was saying. Your query looks like it should work just fine. I've run many similar queries. I was just trying see if you possibly had some NULL debitor_ids in your table to help explain why you're seeing nulls in that field.
I'm also curious if you've run your MySQL Dataflow all the way though to see if the debitor_ids appear in the output dataset and if it's a possible issue with the preview only or an actual issue with the data processing.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith what made me raise a red flag on this is the fact that in DOMO I get a different result than the one on my DB client, my expectation was to have the same error in the two instances if there was one but it only occurs in DOMO, also having nulls should affect both instances, not one.
You have a point, I haven't tried completing the MySQL dataflow since it feels weird completing the MySQL dataflow with the glare of an error. let me see if completing the MySQL dataflow works.
0 -
@Otieno_Onyango please let the dataflow run to completion to see if you still get different results. The preview engine in Domo does not always load the entire datasets. It just loads a small portion of them to minimize processing time. See if you still have the issue after running the complete dataflow.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive