topic Re: data not extracted correctly in App Development

data not extracted correctly

theboss-123 — Thu, 28 Jul 2022 10:49:30 GMT

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

Re: data not extracted correctly

Or — Thu, 28 Jul 2022 10:53:37 GMT

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.

Re: data not extracted correctly

theboss-123 — Thu, 28 Jul 2022 11:49:18 GMT

when i linked the two fild Day and country i got no result

Re: data not extracted correctly

Or — Thu, 28 Jul 2022 12:11:20 GMT

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?

Re: data not extracted correctly

theboss-123 — Thu, 28 Jul 2022 12:14:37 GMT

normally it must return column Void of Futs from first table

Re: data not extracted correctly

Or — Thu, 28 Jul 2022 12:54:19 GMT

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...

Re: data not extracted correctly

theboss-123 — Thu, 28 Jul 2022 13:38:46 GMT

this is the real result , i filter on Spain but it display Nbr de fus consommé of Maroc

Re: data not extracted correctly

theboss-123 — Thu, 28 Jul 2022 14:25:33 GMT

the issue soved thanks for your help