Hi Qlikview team
I have load the below tables and written below script. i have to keep my duplicates in tables.
when i count the record it shows 6 but i load 9 records. when i apply left join with distinct keyword records reduced in main table why.
'201601' as FiscalYrMth,
[BA or SE],
(ooxml, embedded labels, table is Sheet1);
FiscalYrMth as RecID
The DISTINCT predicate will apply also to JOINed and CONCATENATEd tables, i.e. it will be kept as a property of the resident table, that's a Qlik speciality.
Try instead a WHERE NOT EXISTS() clause:
WHERE NOT EXISTS(RecID, FiscalYrMth);