Multiple Names

Infosphere's Quality Product

Moderators: chulett, rschirm

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

Multiple Names

Post by U »

Can QualityStage generate multiple rows from a single row containing multiple names? The kinds of record I'm looking at and required results include:

Code: Select all

Source:  EMILY & BYRON SMITH
Result:   EMILY SMITH
             BYRON SMITH

Source:  E.J. & N. HOLDEN
Result:   E.J. HOLDEN
             N. HOLDEN

Source:  TAMMY & WILFRED BENNETT & KENNEDY
Target:   TAMMY BENNETT
              WILFRED KENNEDY

Source:  PREZZI V & M & P J & M V
Target:   V PREZZI
              M PREZZI
             P J PREZZI
             M V PREZZI

Source:  E.J. & N. HOLDEN & B.L. BAYLY
Result:   E.J. HOLDEN
             N. HOLDEN
             B.L. BAYLY
Thank you for your time.
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

There is room in the output for one parsed name, plus the AdditionalNameInfo field that stores the rest of the multiple name entry.
So you could only use it to take one name out at a time.

You could pass the AdditionalNameInfo output of the first STAN into another STAN and keep doing this until all of the names were processed.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Beat me to it!

For simpler cases you might try using the Looping capability of the Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply