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.