Skip to Content
0
Former Member
Apr 30, 2008 at 08:01 PM

Mapping: convert multiple tables w/ common key to single one w/ that key?

10 Views

Hi,

I need to map this message containing customer information in multiple lists, to a single customer list based on the customer key.

Example:

SOURCE:

Root

...ACCOUNTS... 1

........ITEM... 0-unbound

............CUSTID... 1

............NAME ... 0-1

...PHONES ... 1

........ITEM ... 0-unbound

............CUSTID ... 1

............AREACODE ... 0-1

............NUMBER ... 0-1

...EMAILADDRS...

........ITEM ... 0-unbound

............CUSTID ... 1

............EMAIL ... 0-1

TARGET:

Root

...CUSTOMERS ...1

.......ITEM...0-unbound

...........CUSTID ... 1

...........NAME ... 1

...........PHONES...1

................PHONEITEM...0-unbound

....................AREACODE...0-1

....................NUMBER...0-1

...........EMAILS...1

................EMAILITEM...0-unbound

....................EMAILADDR...0-1

Has anyone done this and can tell me how or at least point me in the right direction? I've been checking the forums but have not seen such an example with multiple tables. I saw a simpler one that uses function SplitByValue, but I'm not sure it can be applied here.

Thanks in advance.

Carlos