View not updating

I have a view of two data sets that are left joined. For some reason one of the columns shows blank for one of the columns in the joined data set view. The weird thing is that it's only for certain rows.
I have checked different filters and looked around to see if there was a refresh button. With no luck.
Best Answer
-
@Josh_Evans20 Is the column with blank values coming from the right table in your join? If so, check whether that value for your join key exists in the right table. If there is no match found in the right table, then any column that comes from the right table will be null for those rows.
In the example below, assume you want to join the left table to the right table on Customer. The right table does not have a row corresponding to the customer "ABC", so there is no Sales for that customer in the output.
As a side note, dataset views update when their input datasets update which is why you don't see a refresh button.
0
Answers
-
@Josh_Evans20 Is the column with blank values coming from the right table in your join? If so, check whether that value for your join key exists in the right table. If there is no match found in the right table, then any column that comes from the right table will be null for those rows.
In the example below, assume you want to join the left table to the right table on Customer. The right table does not have a row corresponding to the customer "ABC", so there is no Sales for that customer in the output.
As a side note, dataset views update when their input datasets update which is why you don't see a refresh button.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive