Skip to Content
0
Former Member
Jan 06, 2011 at 11:02 PM

Data Services: mapping to target based on source data

380 Views

I have a question regarding mapping in DS.

Example: source table contains multiple fields where address can come from and I want to map to a single field in the target.

source-address1 / source-address2 / source-address3 --> Target-address

All of the three source fields can contain data in a single record.

If source-address1 not = u2018 u2018 use this..

Else.

If source-address2 not = u2018 u2018 use this.

Else.

If source-address3 not = u2018 u2018 use this..

How do I accomplish the above in mapping?

Thanks.