Search found 30 matches
- Mon Mar 26, 2012 7:13 pm
- Forum: IBM QualityStage
- Topic: Explicible UNCERT result?
- Replies: 4
- Views: 4161
Hello, Thanks for the replies so far. We are not using disagreement weights, nor declared it CRITICAL. We are seeing them because we are looking at the match pairs in the Test Environment and seeing the weight contribution of that variable. (First name and sex are typo free and getting full agreemen...
- Mon Mar 26, 2012 3:17 pm
- Forum: IBM QualityStage
- Topic: Explicible UNCERT result?
- Replies: 4
- Views: 4161
Explicible UNCERT result?
In the midst of our integration, we are getting results that might be explicible in some way but since we don't know the internal comparison algorithm, I don't know if this is correct. Using a cutoff of 800, all these comparisons were given full disagreement weights: ANDERSON and ANDERSEN AITKIN and...
- Thu Aug 18, 2005 7:45 pm
- Forum: IBM QualityStage
- Topic: Remove trailing numbers
- Replies: 1
- Views: 2334
Re: Remove trailing numbers
A rule like:kommven wrote:I want to remove only the trailing numbers from my data
Code: Select all
#^
RETYPE [1] 0
Cheers,
Jamas
(All this and more can be foudnin your handy-dandy Pattern Action PDF guide...)
- Thu Aug 18, 2005 7:42 pm
- Forum: IBM QualityStage
- Topic: USING RULES Need help Overiding and stripping
- Replies: 6
- Views: 4769
Again, probably easier outside QS, but...kommven wrote:I need to strip away everything in parenthesis
Code: Select all
\(|**|\)
RETYPE [1] 0
RETYPE [2] 0
RETYPE [3] 0
Cheers,
Jamas
- Thu Aug 18, 2005 7:40 pm
- Forum: IBM QualityStage
- Topic: USING RULES Need help Overiding and stripping
- Replies: 6
- Views: 4769
Re: USING RULES Need help Overiding and stripping
I have a URGENT requirements to strip of all the characters after ':' and ';' including. Probably a lot easier in DS, but if you must use QS: Firstly, have ':' and ';' in your sep, but not strip lists. Then a rule like :|**|$ RETYPE [1] 0 RETYPE [2] 0 ;|**|$ RETYPE [1] 0 RETYPE [2] 0 ** COPY [1] {O...
- Thu Aug 18, 2005 7:31 pm
- Forum: IBM QualityStage
- Topic: USADDR standardizing CR as COUNT (not CIRCLE, not COUNTY RD)
- Replies: 2
- Views: 2957
Re: USADDR standardizing CR as COUNT (not CIRCLE, not COUNTY
Any suggestion how to make QualityStage see the first as 1525 COUNTY ROAD 10 and the second as 1525 KELTY CIR? Firstly, is this a hard and fast rule you want to programme? Is it always the case that <name> CR = CIR? (Or basically, is there always a pattern that will be CR = CIR?) If so, add that pa...
- Sun Jul 17, 2005 2:41 pm
- Forum: IBM QualityStage
- Topic: Many to Many relationship matching between 2 files
- Replies: 8
- Views: 6765
Yes it does matter for the performance...but does it really matter for the functionality....because i am still not convinced even after lots of testing... Can't think of a major reason why it should matter, but then again the order of the files in a typical one-one matching matters functionally...(...
- Thu Jul 14, 2005 2:48 pm
- Forum: IBM QualityStage
- Topic: Many to Many relationship matching between 2 files
- Replies: 8
- Views: 6765
Which one is suitabe for me if I need to have many to many matching in QS...? Given FileA and FileB, records A1, A2, B1, B2, B3, say we get the following record pairs and weights: A1,B1 20 XB ('the' matched record) A1,B2 20 DB (duplicate on B) A1,B3 15 DB (duplicate on B) A2,B1 15 DA (duplicate on ...
- Wed Jul 13, 2005 2:39 pm
- Forum: IBM QualityStage
- Topic: Many to Many relationship matching between 2 files
- Replies: 8
- Views: 6765
Re: Many to Many relationship matching between 2 files
Can I do a many to many match in Qualitystage using Match stage...? Look at GEOMATCH DUPLICATE. This allows many records on File A to match to many records on File B (as long as the "duplicate" records on File B are above the duplicate cut off, so simply leave it at 0, or make it the same...
- Thu May 26, 2005 3:42 pm
- Forum: IBM QualityStage
- Topic: Match Cutoffs and Clerical Cutoffs
- Replies: 7
- Views: 5549
Re: Match Cutoffs and Clerical Cutoffs
Hello, (I'll assume for the moment that you're not asking for where to set them (the MATCH stage) and that you know how to create a report/extract file to see what the results are.) I find the best way to work when I get a new file is to set the match and clerical cut offs to zero (because you can't...
- Tue Apr 19, 2005 2:53 pm
- Forum: Site/Forum
- Topic: Number of posts in own information
- Replies: 5
- Views: 5036
Number of posts in own information
Hello, Currently, on the main page, we see stuff like "Number of Points Earned" and "Number of New posts". How about "Number of Posts posted" or something? Even if we can't make the top 10, some of us might like to find out just how we have done (without looking at all ...
- Tue Apr 19, 2005 2:51 pm
- Forum: IBM QualityStage
- Topic: match fields
- Replies: 2
- Views: 2938
Re: match fields
Right now, I'm able to retrieve either all the records with matching NUM & ACC or those records with matching NUM & different ACC, but not as per the requirement. can someone help me ? Herm. Interesting. Off the top of my head, I would say use a Match Stage with Undup on NUM and ACC and GRO...
- Sun Apr 17, 2005 6:48 pm
- Forum: IBM QualityStage
- Topic: Which stages to use?
- Replies: 4
- Views: 4257
Re: Which stages to use?
Hi, I am new to QS. I need to do the follwing transformations. Which stages should i use and how? Ignoring DS solutions, this could be done with custom built rule sets in a Standardise stage, making sure most of the SEPLIST isn't in the STRIP list. But it would take a while to write, especially for...
- Sun Apr 10, 2005 3:02 pm
- Forum: IBM QualityStage
- Topic: Can we get Fields used in Matching from the deployes Script
- Replies: 7
- Views: 5900
Re: Can we get Fields used in Matching from the deployes Scr
Can we find out which fields are used in the matching job from the deployed script. This is more a Windows answer than a Unix answer, but it's the only one I got and have no idea if there is a Unix equivalent. If you can locate the working directory where it compiles all the scripts where running, ...
- Thu Mar 31, 2005 2:43 pm
- Forum: IBM QualityStage
- Topic: test the data
- Replies: 9
- Views: 8357
Jamas, The original requirement is for the field where every letter in the description field has to be checked for upper case. Your solution deals only with the first character of the entire field. Yes, quite right, quite right... Erm, can't think of a simple way to do that in QS then. Maybe someth...