If I run the updated code on
OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
6 Data row
7 Data row
8 Data row
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category
6 Data row
7 Data row
8 Data row
I am left with
OrganizationDate
2 Data row
3 Data row
4 Data row
Life Sciences
10 Data row
11 Data row
12 Data row
So for point 1 check the spelling of the Life Sciences category in your document matches that in the KeyTerms string (and that includes the number of spaces between the two words)
For 2 I can't reproduce what I think you are saying in that you are getting
OrganizationDate
2 Data row
3 Data row
4 Data row
Undefined category
Life Sciences
10 Data row
11 Data row
12 Data row
Undefined category
Which I don't.
|