DSXchange

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...

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...

kommven wrote:I want to remove only the trailing numbers from my data

A rule like:
should destroy any numbers at the end of the string.

Cheers,
Jamas

(All this and more can be foudnin your handy-dandy Pattern Action PDF guide...)

kommven wrote:I need to strip away everything in parenthesis

Again, probably easier outside QS, but...
And then either spit out the string or process elsewhere... (same warning as before re: coding)

Cheers,
Jamas

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...

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...

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...(...

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 ...

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...

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...

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 ...

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...

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...

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, ...

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...