Number of files in data-driven categories

[rienvanham]

Hello Mario,

I've another "challenge" with iMatch which I don't get.

I've made 2 data-driven categories:

1:
Based on variable: {File.MD.hierarchicalkeywords|contains:{File.MD.city},YES,NO,true}
File Formats: .arw;.dng;.heic;.jpeg;.jpg;.nef;.png;.psd;.tif

2:
Based on variable: {File.MD.hierarchicalkeywords|contains:{File.MD.country},YES,NO,true}
File Formats: .arw;.dng;.heic;.jpeg;.jpg;.nef;.png;.psd;.tif

Number 1 returns: 18.559 files (18.559 YES)
Number 2 returns: 18.645 files (81 NO; 18.564 YES)

Why does it select more files at number 2? If I click on NO (81 files) I see 81 PDF's. Based on File Formats I shouldn't expect these files.

(I'm affraid i'm doing something wrong again but I can't find out what).

Thanks in advance,

Rien.

[Mario]

Hard to tell without having the database.
Do you use "Other" for both? If so, how doe Other differ.

Consider empty city or country tags and what your variable returns in that case. Did you try it?

Better would be to use default with a value that does not show in your keywords, e.g.

{File.MD.hierarchicalkeywords|contains:{File.MD.city|default:NNNN},YES,NO,true}

A contains with an empty/null value may be always true...?

Note that having multiple data-driven categories based on variables can be a performance killer (make them manual at least).

[rienvanham]

Hi Mario,

Thanks for your answer. The update with "default" brings no change in the number of files. I'm going for a short holiday now and will try more things after it.

Your warning: yes, I made these queries all "manual".

Cheers,

Rien.

[Mario]

I get the same counts for both categories (total) but slightly different counts in Other, depending on the actual keywords and if they contain country/city.