- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
data not extracted correctly
Hello ,
please shouldbe informed that i have two table as below i linked the two table using default jointure on "Day" Column
First Table :
Second Table :
when i extract data using filter on 14/04/2022 and Spain it diplay corrcetly TR and NR but from first table it display Futs 12 of morocco
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think you answered your own question:
"i linked the two table using default jointure on "Day" Column"
If the tables are only linked by day and not linked by country, then the correct total for 14/04 is 12. If you want the countries to also be linked, you should link that field as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
when i linked the two fild Day and country i got no result
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nothing is the correct result for 14/04 when picking Spain, as there are no lines associated with that set of values in the first table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
normally it must return column Void of Futs from first table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm sorry, I don't understand what "Column void" means, or why you'd expect to get any sort of result when you filter for a combination which doesn't exist in the table...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this is the real result , i filter on Spain but it display Nbr de fus consommé of Maroc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the issue soved thanks for your help