Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
i have to count how many records in table A are in table B (for each year).
i have creted a resident table whith this script
table_a:
load TMP_KEY AS MATCH_KEY,
BARCODE_MATCH_OR AS MATCH_BARCODE_OR,
BARCODE_MATCH_AR AS MATCH_BARCODE_AR,
ANNO,
IF(BARCODE_MATCH_OR=BARCODE_MATCH_AR,NUM(1),NUM(0)) AS MATCH_CONTA
RESIDENT
MATCHATI_TMP;
TMP_KEY BARCODE_MATCH_AR BARCODE_MATCH_OR ANNO MATCH_CONTA
431525 431525 431525 2010 1
431867 431867 431867 2010 1
431915 431915 431915 2010 1
434535 434535 2010 0
the table_a contain 19663 records.
whith a pivot table i could sum the "match_conta" value .
I use the dimension ANNO but the result is wrong.
I don't understand why the sum(match_conta) return 106506
Someone can help me.
Many Thanks
Riccardo
Riccardo,
To match the 2 tables are you doing a join? If so, I would make sure that the join is not wrongly duplicating the rows.
Regards.
Hi Karl,
yes i have done a join for optimize
but ... If i display all fields for the target table with an ordinary table the system show me 19663 records, 11616 of these have the
fields "match_conta" = 1 .
So i suppose to have a value like 11616 for year ...
I'm not so expertize .. so i probably doing a mistake...
Many thank's Riccardo
HI,
Can you post your app?
Hi ,
yes of course .. and many thank's ..
Riccardo
Dear all
i have found the mistake!!!
i counted the null value .. 😞
Sorry !! and thank's for helps