Remove Duplicate Title

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Remove Duplicate Title

Post by U »

We have data in which the title is duplicated, for example "MRS MRS JENNIFER TAYLOR" and want to use Pattern-Action Language to remove the duplicate.

We tried:
P | P [ {} = [1] ] | **
RETYPE [1] 0

but this generated an error in the Test utility.

Can someone with PAL experience please suggest a valid way to achieve this requirement?

Thank you for your time.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Although it's double-handling to some extent, the following should work.

Code: Select all

P | P | **
COPY [1] temp1
COPY [2] temp2

P | P | ** | [ temp1 = temp2 ]
RETYPE [1] 0
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
U
Participant
Posts: 230
Joined: Tue Apr 17, 2007 8:23 pm
Location: Singapore

Post by U »

That works and we will use it in our rule set.

Thank you again for your time.
Post Reply