Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to filter to see only data in a data set not matching with data in another data set
Summary
How to filter to see only data in a data set not matching with data in another data set
Content
Hi,
I am trying to create a simple project to show me what are the cities without population.
I have 2 data sets: one with 2 columns (city name, population no) and one with 1 column (city to find population).
Data set 1:
| City A | Population A |
| Madrid | 30k |
| Paris | 100k |
| Bucharest | 20k |
| Sofia | 10k |
Data set 2:
| City B |
| Paris |
| Bucharest |
| Moscow |
| Madrid |
| Sofia |
| Istanbul |
How can I see in a project that I don't have a population for 2 cities (Moscow and Istanbul)? As you can see in the picture link below there is blanks on the rows with cities not found but how can I make DV to show only those 2 rows not all 6?
Picture with the project here: https://ibb.co/e1kBDb
Thank you,
Adrian
Answers
-
I have 2 data sets already. I need to show only the 2 cities without population.
If I use a filter I get all as blanks. See picture ... https://ibb.co/nuEN66
0 -
You haven't provide a whole lot to go on, but if you're looking to create a new data source with just the cites missing population, take a look at Data Flows. Otherwise, I would think you could just use filters.
0 -
Try making your population column a measure instead of an attribute.
0