Address Parsing Help Parallel Transformer

nekeda7 · Post by **nekeda7** » Wed Jul 30, 2014 7:52 am

Source Data (sample data provided below)

AddrLn1, AddrLn2, AddrLn3
123 main st, null, null
C/O James, 456 Corporate Rd, null
C/O Greene, HR Dept, 487 Field St

Mapping Rules
If AddrLn1 has 'c/o' or 'Attn', use AddrLn2 Else AddrLn1. this is mapped to target field EmplAddrLn1

If AddrLn2 was used for ADDRESS_LINE_1, look at AddrLn3. Skip address line with 'c/o' or 'Attn'. this is mapped to target field EmplAddrLn2

I need help with function to be used in parallel transformer and proper syntax for it.

chulett · Post by **chulett** » Wed Jul 30, 2014 8:05 am

Start by looking at UpCase() so you don't have to worry about "Attn" versus "ATTN" (etc) and then Index() to determine if those substrings are present. Any answer other than zero = yes.

nekeda7 · Post by **nekeda7** » Wed Jul 30, 2014 8:26 am

Does this look right to put in transformer for target field EmplAddrLn1

Code: Select all

If Index(UpCase(Lnk_HardCodeValues_in.ADDRESS_LINE1), "C/O" or "ATTN")<> 0 Then Lnk_HardCodeValues_in.ADDRESS_LINE2 Else Lnk_HardCodeValues_in.ADDRESS_LINE1

nekeda7 · Post by **nekeda7** » Wed Jul 30, 2014 9:07 am

Anyone else have any other ideas to implement this requirement????

chulett · Post by **chulett** » Wed Jul 30, 2014 9:51 am

I deleted the duplicate 'urgent' topic you opened with this exact same question in it. Let's play here.

The code you posted is fine in spirit but the syntax is wrong. You cannot use an "or" there, you need to repeat the test for each thing tested for. And with zero being equal to FALSE and non-zero equating to TRUE you can simply things.

Code: Select all

If Index(UpCase(Lnk_HardCodeValues_in.ADDRESS_LINE1), "C/O") or Index(UpCase(Lnk_HardCodeValues_in.ADDRESS_LINE1), "ATTN") Then Lnk_HardCodeValues_in.ADDRESS_LINE2 Else Lnk_HardCodeValues_in.ADDRESS_LINE1

See if that works for you.

ps. Stage variables to hold things like the UpCase'd ADDRESS_LINE would make this more efficient.

nekeda7 · Post by **nekeda7** » Wed Jul 30, 2014 9:58 am

Thanks chulett.

Transformer stage is not accepting that code in the derivation.Throws that red error bar

This one works though after i add comma 1 to each one. What is the 1 indicate after the address in this syntax?

If Index(UpCase(Lnk_HardCodeValues_in.ADDRESS_LINE1),"C/O", 1) OR Index(UpCase(Lnk_HardCodeValues_in.ADDRESS_LINE1),"ATTN", 1) Then Lnk_HardCodeValues_in.ADDRESS_LINE2 Else Lnk_HardCodeValues_in.ADDRESS_LINE1

chulett · Post by **chulett** » Wed Jul 30, 2014 11:16 am

These functions are documented and that would be explained there. It signifies the "occurrence" of the substring, here meaning the first.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 30, 2014 10:17 pm

I'd be using a Standardize stage (QualityStage component) with an appropriate address rule set (e.g. USADDR).