Page 1 of 1

How do you see the rows which have fallen into unhandled pat

Posted: Tue Sep 26, 2006 4:21 pm
by abc123
How do you see the rows which have fallen into unhandled patterns?

Posted: Tue Sep 26, 2006 4:59 pm
by kris007
What do you exactly mean by unhandled patterns?

Posted: Tue Sep 26, 2006 7:14 pm
by ray.wurlod
"Unhandled pattern" is a column in the report from an Investigation. If that field (unhandled pattern) is populated, then the row has an unhandled pattern. Note that there is also "unhandled string" which can be useful in deciding whether or not you need to create a new rule or a rule override.

Posted: Tue Sep 26, 2006 9:28 pm
by kris007
My Bad. Didn't realise that the post was related to Quality Stage and hence the confusion.

Posted: Tue Sep 26, 2006 10:31 pm
by abc123
ray and kris, thank you very much for your posts. ray, can you tell me how I can find out which rows have unhandled patterns? For example, if there are 1 million rows and 3000 of them fall in a pattern, how do I look at those 3000 only? The PAT, FRQ and SRT files don't have that info.

Is there a technique that you gurus use that you can share? Thank you very much.

Posted: Wed Sep 27, 2006 1:06 am
by ray.wurlod
The SRT file is sorted by pattern. But that doesn't mean you can't re-sort it by unhandled pattern, or run it through a filter that eliminates those rows that have an empty (all spaces) unhandled pattern field.

Posted: Wed Sep 27, 2006 8:02 am
by splayer
So really there is no way other than manually going through the data?

Posted: Wed Sep 27, 2006 2:49 pm
by ray.wurlod
Correct. In the fullness of time, as you tune your rule set and rule overrides, you expect to have fewer unhandled patterns. You will always, of course, have unclassified tokens, but these can still be handled in patterns. For example in the ?,FI pattern the unknown token in a name rule set is going to be placed into the LN (primary name) bucket.

Re: How do you see the rows which have fallen into unhandled

Posted: Thu Sep 28, 2006 7:26 am
by Alexander
You can use a DCT field to store a value which time a pattern is used.

But to achive this you will need to change your pattern file.

At the end, the DCT field will have a value match to the pattern that treat which record. If its empty, no pattern had match.