DSXchange

Posted: **Tue Jan 21, 2014 6:03 pm**

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.

Posted: **Tue Jan 21, 2014 7:33 pm**

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.

Posted: **Tue Jan 21, 2014 8:40 pm**

Beat me to it!

For simpler cases you might try using the Looping capability of the Transformer stage.

DSXchange

Multiple Names

Multiple Names