Field doubt in mapping

[Former Member]

I have a mapping scenario where I have to combine address.

ADRNR[1,12] + ' ' + ORTO[1,10] + ' ' + REGIO + ' ' + LAND1

ADRNR is in the source and it has to be mapped to ADDRESS and it is the condition for mapping. How do I do this ?

Right under ADRNR, I have the fields ORTO, REGIO AND LAAND1 whiucih has to be mapped to CITY, STATE, ZIP CODE and Country.

So can I use Field ORTO in source to map with ADDRESS and also CITY again ? I mean can one field be used for two mappings

structure is like this

ADRNR mapping rules ADDRESS

ORTO CITY

REGIO STATE

LAAND1 COUNTRY

The last three are just field to field mapping

Regards

[rajasekhar_reddy14 · Accepted solution]

Hi Ajith,

use substring and concatnation functions and try it,i hope it will work..

Regards,

Raj

[Former Member · Accepted solution]

Hi,

If the issue is still outstanding can you please provide a

1) sample input

2) sample output

regards,

[Former Member]

> I have a mapping scenario where I have to combine address.

>

>

ADRNR[1,12] + ' ' + ORTO[1,10] + ' ' + REGIO + ' ' + LAND1

>

> ADRNR is in the source and it has to be mapped to ADDRESS and it is the condition for mapping. How do I do this ?

Use substring & Concat function, or write an UDF to concatenate them.

>

> Right under ADRNR, I have the fields ORTO, REGIO AND LAAND1 whiucih has to be mapped to CITY, STATE, ZIP CODE and Country.

>

> So can I use Field ORTO in source to map with ADDRESS and also CITY again ? I mean can one field be used for two mappings

Yes, you can use them as many times as you want.